>HI,
>I need to display 35K rows of 75 fields each for validation process to a user. My backend is Oracle and I access it through ADO. Everithing is fine but when I load my form, it takes 1-2 mins to show up and when the user is scrolling the datagrid, it takes 5 secs before it scrolls. I do know that the problem is related to the 35K rows I am loading so I tried to limit the number of rows.
>
>I issue "SELECT * FROM MyOracleTable WHERE ROWNUM < 100" and it retreives me the first 99 rows. When I want to issue this through a command object, I send two parameters in order to have a sql string like this :
>"SELECT * FROM MyOracleTable WHERE ROWNUM >firstparameter and < secondparameter"
>
>However, I get an error message from the grid when I want to set Mygrid.datasource = MyRst telling me that the cursor is not bookmarkable.
>
>Do I need to use another ActiveX control or is there something I should change in my logic ?
>
>Thank you for your help,
>Christian Cote

Also, have a look at http://support.microsoft.com/support/kb/articles/Q278/4/08.ASP