[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