How to increase the performance of table

Question

0.00/5 (No votes)

See more:

SQL

In my project i have 20000 records in one table.
if i run the table i get more time to retrieving the date

Any Possible to retrieve the date quickly from the database

What I have tried:

select * from table_name

it takes more than 20 seconds to retrieving date from database

Posted 5-Feb-16 21:01pm

V Senthil Kumar

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-02-05T21:34:00

jgakenhe makes very good points - but start by looking at the data you are retrieving. I can fetch 21024 rows from my SQL Server table in under a second, purely because the volume of data I am retrieving is trivial: 1 int ID, and 1 NVARCHAR(260) is all. So look at what you are fetching, and at the speed of the link between the SQL server PC and the client

Then look at exactly what you are doing with the data: if you are trying to load that into a display control of any form, then that is always going to be a slow process.

Sorry, but we can't wave a wand and say "It's this line: change it to such-and-such" because there are just so many different things you could be doing to slow down the data.
But me? I don't fetch any more rows or columns than I need at the moment - it's always going to be data traffic intensive.

jgakenhe · Answer 2 · 2016-02-05T21:16:00

It's going to be slow, that is a lot of records to return.

1) Make sure you have a primary key.
2) Return only the rows you need; meaning filter by the primary key or another column.
3) Select only columns you need. If you have big columns you don't need, then don't include in your query; such as: image, varchar(max), ect...

Also, you should not typically need to return 20000 records. 20000 records will bring down a web browser and will print to 100's of PDF pages.

How to increase the performance of table

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0