rda.SubmitSQL performance tip.

  • Thread starter Thread starter chris-s
  • Start date Start date
C

chris-s

Hi,

We have a data update process whereby records are inserted into a SQL server
db from the device using the rda.submitsql method, executing it once for
each insert statement. The existing process was taking 1 1/2 minutes for a
certain number of records.

It never occured to me, until now, to try creating a single string with all
the insert statements in and submit it once, which performed the same
process with the same data in 6 seconds!

Maybe everybody already knew this, if not, and you are doing something
similar, you might like to try it.

Cheers,

Chris
 
Update....

After a bit of experiementing with the number of insert statements contained
in the string, in some cases, fewere was better than many, eg an update that
was taking around 4 minutes, when performed in blocks of 500 updates was
reduced to around 1 minute, when changed to perform inserts in blocks of
100, the time was further reduced to around 40 seconds.

Chris
 
Back
Top