• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database

 
suresh pulapally
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 169
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic