Sql Server Fetching Data

[Ravi_21]

Hi there, i have a sql server table there i have thousands of record and when i call it from Stored procedure then it will take very huge time to display records how can i make Fast. Thanks in Advance

[Groulien]

Returning thousands of rows is usually not the problem. The problem is usually in the query (your stored procedure). It might help if you were to post the Stored Procedure?

[Simon_Whale]

Without your query I can only suggest things to try as I had to do something similar just recently 1. Break your query down into sections and find what part is slow 2. Indexing your data. or like the other poster suggested, post your query

Nagy Vilmos wrote:

And eat bacon. Bacon's real important for 'puters.

[SilimSayo]

The general answer is write more efficient code. Since you haven't posted your code, we can't tell you where to improve it.

[jschell]

In general you shouldn't be attempting to display "thousands" of records in the first place. This typically occurs in list box type displays for users who are interested in looking at the records. But those users don't want 'thousands" what they want is a very small subset very likely one record. And they know what they are looking for. So only display the single record they are looking for.

[Lost User]

Posting your query will help us determine your problem, but here are some general tips: 1. Index your table(s) properly. 2. Select only the required rows using a properly constructed WHERE clause. 3. Select only the required columns.