VB & Database, Higher Performance Method

Higher Performance Method

Author	Message
John Hutc #1 / 3	Higher Performance Method I'm presently using the GetRows method to extract a two dimensional array from an ADO recordset, and would like to modify the two dimensional array slightly, and write it back to a database table. I've experimented with using the .AddNew and .Update methods but I have not been satisfied with the performance. Are there any methods out there that i have overlooked? Thanks.
Sun, 22 May 2005 06:34:31 GMT

Atrax #2 / 3	Higher Performance Method if you're just modifying data why aren't you using SQL updates? ________________________________________ I got bored with my old signature, so I changed it Atrax. MVP, IIS http://rtfm.atrax.co.uk/ * Sent via Developersdex http://www.developersdex.com * Don't just participate in USENET...get rewarded for it!
Sun, 22 May 2005 11:51:12 GMT

Val Mazu #3 / 3	Higher Performance Method John, Why not to change values directly in recordset? Also, probably it is possible to create some sort of UPDATE, which will modify records directly in database, but it depends on what you need to achieve -- Val Mazur Microsoft MVP Quote: > I'm presently using the GetRows method to extract a two > dimensional array from an ADO recordset, and would like to > modify the two dimensional array slightly, and write it > back to a database table. I've experimented with using > the .AddNew and .Update methods but I have not been > satisfied with the performance. Are there any methods out > there that i have overlooked? > Thanks.
Sun, 22 May 2005 12:05:24 GMT

Page 1 of 1

[ 3 post ]