[Babase] Re: Shh...babase is thinking...
Karl O. Pinc
kop at meme.com
Mon Apr 19 10:36:48 EDT 2010
On 04/19/2010 09:13:42 AM, Niki Learn wrote:
> Karl,
>
>
>
> Can you give me any idea why babase can't seem to run this? It just
> keeps
> thinking and thinking for hours.
I don't see you "connecting" snames between the different
tables. So, you get _gobs_ of results, every possible
combination of every members row in those groups, with
every possible female cycle, ever.
One way to help debug this is to add something like
"LIMIT 1000" to the end and see what you get.
You can also try removing some tables and see if
you get what's expected at that point.
>
>
>
> select members.grp, mtd_cycles.sname, mtd_cycles.tdate,
> mtd_cycles.ddate,
> (mtd_cycles.ddate - mtd_cycles.tdate) as DminusT, repstats.state as
> repstat,
> extract(year from mtd_cycles.tdate), extract(year from
> mtd_cycles.ddate)
>
> from members, mtd_cycles, repstats
>
> where members.date = mtd_cycles.ddate and repstats.date =
> (mtd_cycles.ddate)
> and members.grp in (1.0, 1.1, 1.21, 1.22, 2.0, 2.1, 2.2)
>
> order by members.grp, mtd_cycles.sname, mtd_cycles.ddate;
>
>
>
> Thanks,
>
> Niki
>
>
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