[Babase] troublesome query

Karl O. Pinc kop at meme.com
Thu May 20 14:58:50 EDT 2010


On 05/07/2010 03:25:28 PM, Susan Alberts wrote:
> Lacey and Karl,
> 
> Here is the query we were just talking about that took a long time to 
> 
> process.
> 
> select *
> into alberts.gcounts
> from actor_actees, biograph, maturedates
> where actor_actees.actor = biograph.sname
> and maturedates.sname = biograph.sname
> and actor_actees.date > maturedates.matured
>   and biograph.matgrp < 2.9
> and biograph.sex = 'F'
> and actor_actees.act = 'G'

Lacey and I took a look and figured out that the
slowness was not in the database but in the
work ppa does to present the data.  I believe the
fastest choice was "text, all one page".




Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein




More information about the Babase mailing list