Board index » delphi » SQL Server Speed Issue
Alteren, Ramon van (DSA)
![]() Delphi Developer |
Wed, 18 Jun 1902 08:00:00 GMT
SQL Server Speed Issue
Hi
>I have a speed problem with large batches in SQL server 7.0 A batch that >took 2 hrs to execute in paradox now takes 13 hrs to execute in SQL SVR 7! As other people pointed out, if you're using the same logic as you >The batch process basically does the following ... >1. Loop throught table (while not eof) Why not try something along the following lines >I have the same indices in SQL that I had in Pdox. Could my problem The indices should *probably* on the field which you're checking against the Have fun Grtz Ramon Quote> _____________________________________________________________ Before you buy. |