June 19, 2008 at 2:13 am
Hello!
I am java programmer using SQL Server 2000 database as the back-end. When i retrieve the records from the table it takes huge time or even times-out the execution of the query because of bulk records (more than 1000's of records) in the table. Will you suggest me any alternate to increase the performance of the query, the equivalent of the optimizer technique available in Oracle with respect to SQL Server that will be helpful in retrieval of records in a faster way.
June 19, 2008 at 2:53 am
At a very high level, I'd suggest:
- consider whether you have the appriopriate indexes on the data you are querying.
- looking at the query execution plan, may help to identify issues with the code. Using other tools like Profiler/Trace, may help to identify other issues.
- retrieving data through a stored procedure can have performance benefits, as well as security and maintainability benefits.
- only retrieve the columns of data you actually need
June 20, 2008 at 3:10 am
As well as the above suggestions , are you certain it's a database issue ?
Have you run a trace , to see if there are other issues regarding delays?
Is the client application efficient?
http://www.ITjobfeed.com
June 20, 2008 at 8:04 am
Why are you retreiving 1,000's of rows into an application? What is it that your'e actually trying to do with all that information? This isn't a challenge... I just need more information...
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply