iam using preparedstatement to fetch data from db,the no of rows nearly(40k) so its taking long time(appr 10min),but my requirement is one minute... pls help me how to do..(iam using 4th driver)
Joined: Dec 19, 2001
Might want to post your code which is doing the query. This code should include both the connection string as well as the prepared statement query sequence / strings.
Joined: Feb 11, 2002
Do you have indexes set up at the database level??? Do you really need to retrieve 40,000 rows? Take a look at implementing paging. You'll need to post more info in order for any of us to be of more help.
Joined: Aug 15, 2004
As it is about 40k rows. I assume you are not filtering records. In full table scan indexes can't help. But yes pagination is important. I dont think you are gonna display full 40k rows in one shot.
Joined: Mar 15, 2005
i required total no of rows bcoz my requirement is to display tree structure...i never used pagination , i need some information on pagination.