Maybe I'm a bit naive in saying this but. . .
SQL joins are damn slow! I have a simple database of about 37,000
records in [Court Cases] and 2,000,000 records in [Defendants] (soon to
be more). When I do a search on [Defendants] (the big table) alone, a
saerch can go in like .7 seconds
Steve,
SQL joins are damn slow! I have a simple database of about 37,000
records in [Court Cases] and 2,000,000 records in [Defendants] (soon
to
be more).
Please post the structures of your 2 tables (at least, the relevant
parts), and the join query that gets so slow. Otherwise, we can only
Steve Quezadas wrote:
However. I notice that if I do two separate searches it goes quicker
(about 2.5 seconds combined). I can do a criteria search on defendants
and then put all the resulting case numbers in a temporary table. Then
do a join of that temporary table to the much smaller Cases
PROTECTED]
Subject: Joins are damn slow. . .
Maybe I'm a bit naive in saying this but. . .
SQL joins are damn slow!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com