Pardha Saradhi
Top achievements
Rank 1
Rank 1
Pardha Saradhi
asked on 30 Aug 2010, 10:58 AM
Hi,
Telerik Team
I have been using Oracle database which contains huge amount of data,i am doing search operation against one table which contains bulk data(laksh of records). So when i open, my page it is taking around 3-4 minutes to search in the database.
So Please provide me the best soluiton to access/search oracle database and complete my search operations in seconds.
Thanks in advance.
Telerik Team
I have been using Oracle database which contains huge amount of data,i am doing search operation against one table which contains bulk data(laksh of records). So when i open, my page it is taking around 3-4 minutes to search in the database.
So Please provide me the best soluiton to access/search oracle database and complete my search operations in seconds.
Thanks in advance.
1 Answer, 1 is accepted
0
Hi Pardha,
If I understood you correctly, you have narrowed the problem to be caused by the actual data retrieval? As you may know RadGrid, being a UI component is not coupled to a particular data access technology nor database. Having the above in mind, you should consider consulting with your DB Admin in order to optimize and tune-up the actual query (and database's schema) you are executing.
Some general RadGrid optimization tips and tricks can be found here under Controls->RadGrid->Performance tips and tricks
Greetings,
Rosen
the Telerik team
If I understood you correctly, you have narrowed the problem to be caused by the actual data retrieval? As you may know RadGrid, being a UI component is not coupled to a particular data access technology nor database. Having the above in mind, you should consider consulting with your DB Admin in order to optimize and tune-up the actual query (and database's schema) you are executing.
Some general RadGrid optimization tips and tricks can be found here under Controls->RadGrid->Performance tips and tricks
Greetings,
Rosen
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items