Board index » delphi » Slow start
David Pate
Delphi Developer |
David Pate
Delphi Developer |
Slow start2004-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 |
Bill Todd
Delphi Developer |
2004-12-14 06:35:22 AM
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 |