regarding speed

[jitendraverma]

sir,

i m using visual basic 5.0 with oracle 8. i hv given the task to upgrade a module which is running very slow. in my module i m opening the results et as --

set rs=cn.openresultset("select * from ja_m_fty" ,rsopenkeyset,rdconcurbatch)

now thru do while loop at after each row i m doing rs.update and finally at the end of loop, i m doing rs.batchupdate.
it is happening many times in the module. my question is that how can i increase the speed? can i use some property of resultset thru which i can directly update the record?

pls send me the proper solution with an example.

thank u-

jitendra




[sig][/sig]

 

[NickBulka]

Without more details, it's going to be hard to give suggestions. However, one suggestion I do have is to ask this in the Visual Basic Database forum. [sig]<p>nick bulka<br><a href=mailto: > </a><br>[/sig]