Hello Folks!
I don´t know what I´m doing wrong. When I connect to an Oracle database using ADO, it take very long to bring all the 100000 (a hundred thousand) records from the server. Here´s my connection string:
"Provider=ORACLE;Persist Security Info=False;User ID=user;Password=pass;Data" +
" Source=fremont;PwdChgDlg=1;FetchSize=200;CacheType=memory"
I thought "FETCHSIZE=200" would bring just the 200 first records and the others only when needed.
I´m doing some tests here with Oracle 8.1.5 and SQL Server 7 with the default configuration ("factory default") for both databases. These are the results i got to:
- For a large quantity of INSERTs (10000,100000, etc...), Oracle is 3 times faster.
- The query time (doesn´t matter how many rows) the is almost the same.
Anybody agree with me??
TIA
Alonso
Like Frank said: "I did it... MY WAY!"