Database access, ADOBC, recordsets and GetRows

[Daniel13]

Help,<br>
<br>
I am trying to do some Oracle database access programming from<br>
javascript. I have most of my code working quite well, but it is rather<br>
slow - we are doing international access. I believe the speed problem<br>
is due to 'walking' through the recordset that I receive via a "while<br>
not xxx.eof" loop. If I open a sqlplus window, I can make the same<br>
query in 5 seconds that takes javascript minutes to accomplish.<br>
<br>
I believe that the solution is to use GetRows to get all returned<br>
data at once into my server. (The Oracle server is 10,000 miles away<br>
from the web,asp server). However, I cannot get Getrows to work - I<br>
understand it returns a two dimensional array which is supported by<br>
vbscript, but only single dimensional arrays seem to be supported by<br>
javascript.<br>
<br>
Any help with a javascript GetRows example, or hints on speeding<br>
things up would be greatly appreciated!!!!<br>
<br>
Daniel Sefton<br>
sefton@pfizer.co.jp

 

[robherc]

I can probably help you with speeding things up a little if you can post the script so I can go through it & look for little speed-consuming "imperfections." But I'm afraid I haven't even heard of a "GetRows" attribute.<br>
<br>
<br>
-Robherc<br>
robherc@netzero.net