[Openroad-users] speed issue OpenROAD application

[Allan Biggs]

I have a speed issue made worse by a slowish connection to the database 
server from the users PC.

We are unloading (sorry ABF terminology; obviously using a for loop) a 
table field and on each cycle storing the values in a table. This is 
taking 0.5 seconds per row. and there can be 50 to 100 rows in the table 
field. 

I am wondering how to speed this up and am considering writing each row to 
a file (using a 3GL procedure) and then using  'copy table'  to load the 
table. 

Can anyone think of a better way of approaching this 

thanks
Allan

This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean

           http://www.DuPont.com/corp/email_disclaimer.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20071002/2b5e2d56/attachment.html