database

[suresh pulapally]

hi all,

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)

[Jeff Grant]

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.

[Ed Wallen]

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.

-Ed

[Adeel Ansari]

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.

[suresh pulapally]

hi

i required total no of rows bcoz my requirement is to display tree structure...i never used pagination , i need some information on pagination.