proting data through cold fusion

[ratnam]

hi,
i have problem in porting data from ms-access to oracle and i do that through Cold fusion program as the data from ms-access need to shappped properly before sending into oracle data base.
there are 3000 records in a table in ms-access which have 172 fields.
am on windows2000 with coldfusion app server with Apache.
the problem is when i run my program on (xxx.cfm)the time taken for inserting into oracle is varying exponentially and as a result my browser(IE5.0) is giving message operation time out and after little time data is also stopped getting inserted in to oracle.
first record is taking less time and as number of records increases time for processing alsoincreasing.and at the end only half of the records i could insert.
can ne please help me in fixing this as i have very very less time ...
thanx.

 

[iqof188]

There' s a few things you can do:

1. Break the amount of data to be processed in a couple of chunks, so the operation won't time-out. Play a bot with the time-out interval in the CF Administrator.
2. If the data has to be transported from one page to another, use WDDX (it's great for that ) to bring over the recordsets.
3. Do as much of data manipulation in your queries, since DB's usually are faster working with data than CF.
4. Use a tool other than CF to do the transfer, since CF wasn't developed to do this kind of stuff.

Good luck!

<webguru>iqof188</webguru>

 

[GunJack]

You might also want to use Netscape as it won't timeout like IE does. Netscape will wait as long as it takes for the process to run. This won't change the fact that CF will timeout your script after the time take in the CF administrator. To get around this, you can append a timeout variable on to the end of your script to increase the timeout like this,

http://server.com/myProcess.cfm?requesttimeout=9999

where &quot;9999&quot; indicates how many seconds to run for. This allows you to keep a normal timeout but increase it on an as needed basis.

While this won't address the problem of the time it takes, it should at least help you run it in it's current state.

GJ