Board index » delphi » SQL Server Speed Issue
Alteren, Ramon van (DSA)
Wed, 18 Jun 1902 08:00:00 GMT
SQL Server Speed Issue
>I have a speed problem with large batches in SQL server 7.0 A batch
>took 2 hrs to execute in paradox now takes 13 hrs to execute in SQL
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
Sent via Deja.com http://www.deja.com/
Before you buy.