Re: Delphi 6 - ADO - MS SQL Server


"AquaGrrlll" <gnome@xxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:4512a67a$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Well I was talking in relative terms rather than absolute milliseconds.
The
time taken was about 150ms per record to do the edit/post. It doesn't
sound
a lot, but we're expected to process about 700k records and it all adds
up,
of course (29 hours to do the lot). I was just expecting it to halve the
amount of time taken when I used Stored Procs and was rather taken aback
when it didn't.
Where did you get those 700k records, which you need to update? If they are
located on the same server then you should use update with from clause.
Something like this:
update tableA set tableA.Title = TableB.Title from TableB where TableB.ID =
TableA.ID.
If they are coming from the external source and you need fast performance
then you should look at either of this:
1. DTS
2. BCP
3. IRowsetFastLoad
Idea is as follows all those enables bulk insert, i.e. you will create
TableB from external data and than do update against this TableB.


.