>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.

Alonso;

Pulling 100,000 records will take time regardless of what backend is used. The purpose of a back end is normally to obtain a data set, that is a limited number of records that matches a condition or conditions required by the user. If you tell the back end to "give me everything", you will get what you asked for.

By the way, my experience with Oracle and SQL Server allows me to think that results vary with the query and what you are doing and how things are set up. Sometimes I see Oracle doing a bit better of specific queries but not always.

Tom