TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Chetan Sawhney
NA
1
0
DataReader getting slow after fetching 70000 records
May 12 2005 5:18 AM
Hi, I am invloved in a re-engineering project, which requires a table with 900000 records to be fetched in memory. I am using DataReader for the same but surpisingly; it is taking 10 minutes to fetch 80000 records. On debugging, I noticed that DataReader is getting slow in fetching the records after 70000. I have tried using the following providers, but same result 1. ODBC.NET 2. OLEDB.NET 3. ODP.NET I am also pasting the code using OLEDB Provider for reference. OleDbConnection objConnection = new OleDbConnection(ConnectionString) ; objConnection.Open() ; m_strQuery = @"SELECT DEALID,CMDDATE, SEGMENT1 FROM DELIVERYSHAPE WHERE DEALID < 20000 " ; This query will fetch 84,000 records OleDbCommand objCommand = new OleDbCommand(m_strQuery, objConnection) ; OleDbDataReader objReader = objCommand.ExecuteReader() ; while ( objReader.Read() ) { lCounter ++ ; } Database is Oracle 9i and client machine is Win XP. Any suggestions / help / link / pointers would be highly appreciated. Regards Chetan Sawhney
Reply
Answers (
1
)
Records in the Datasource not updated!
Help! Printing on large side (horizontally) on report page (on paper)?