Board index » delphi » Slow start

Slow start


2004-12-14 04:18:13 AM
delphi170
Using D7, Paradox, and LAN with WinXPP and Win2k
While I used only ttable on my program it loaded quickly on each
computer on the LAN. I rewrote much of the program using Query (SQL),
and it takes several minutes to load. Could the presense of the SQL
statements have anything to do with this?
Thanks,
David
 
 

Re:Slow start

Yes. Paradox has an extremely poor optimizer and does not perform SQL
statements well. Performance will be worse if you select all rows in
the table. Using TTable is much better with Paradox tables.
--
Bill Todd (TeamB)
TeamB cannot answer questions received via email