Problem with Table having huge amount of data

create indexes on this table. so you can fetch records in less time

As OriginalGriff mentioned (general pointers for performance):

1) Server side paging.
2) Indexing on the tables on the columns that are used as filters.
3) Simplifying the queries and getting rid of complex and redundant joins.
4) Using AJAX on the client side to load data only when needed.
5) Caching frequently accessed but rarely changing data, (Be very careful with this).
6) Optimising your code to simplify and eliminate loops (redundant ones).

It all really depends what your slow queries are and where exactly in the code is a performance hotspot.

Cheers.

You need to figure out what exactly is taking so long, like OriginalGriff said. Basically there are a few things you can look at:
* Load the query in SQL Manager and check there. If that is taking long, you found the origin of the problem, if not the problem is in your code.

Database
* Are there indexes and shouldn't they be rebuilt ?
* Do you have a lot of large objects (BLOB eg) ?
* How complex is the query, make sure that the query is built in such a way that the indexes are used! Basically, although it depends on database, it means that if you have NULL values in the column, if you use functions (eg toUpper, ...) the index is not used. Read up on the cases for your database.

Code
A lot can go wrong here.
* make sure you aren't copying objects needlessly around.
* Make sure you don't have loops that contain a lot of string concatenations, use StringBuilder for that.
* debug, debug, debug ... I often use logs and log information messages with the timestamps... helps a lot...
* is the network slow?


hope this helps.

A most common situation,

In one word: Paging
Can be done as folks here suggested on the server side GUI handling.

But

It can also be done on the DB side, create a stored procedure that will deliver bulks of BULK_SIZE number of rows in return.

Cheers,
Edo