how to select 10000 records from a table in 10 seconds

Question

1.00/5 (6 votes)

See more:

hi all,

I have 100000 record in a table,

i want select 10000 records with in 0 seconds,

If i use select query like

SQL

select top 10000 * from table1

it takes me 25 to 50 seconds

can you help me

thanks advance.

Posted 7-Apr-14 4:47am

Murugesan22

Updated 14-May-14 5:16am

v4

Add a Solution

Comments

Richard MacCutchan 7-Apr-14 12:23pm

Have you ever heard of the Laws of Physics? You cannot do anything in 0 seconds.

phil.o 14-May-14 11:25am

Yes, you can, if you admit the possibility of an infinite speed :)

2 solutions

Solution 2

I'd like to say it's a very poor idea to load large portion of data!

Have you ever heard about paging[^]?

Have a look here:
Tutorial 25: Efficiently Paging Through Large Amounts of Data[^]
Paging SQL Server result sets[^]

More on CP KB[^].

Posted 7-Apr-14 11:40am

Maciej Los

Comments

Mehdi Gholam 8-Apr-14 3:56am

Touche :)

CPallini 14-May-14 12:28pm

5.

Maciej Los 14-May-14 12:47pm

Thank you, Carlo.

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)

Mehdi Gholam · Accepted Answer · 2014-04-07T05:18:00

Solution 1

You cannot select anything in 0 seconds, usually it will take some amount of time >0.

To select 10,000 records from 100,000 records you can do the following (if you don't have a filter to work with):

SQL

select top 10000 * from table1

To make things faster you can add indexes to your table.

Posted 7-Apr-14 5:18am

Mehdi Gholam

Comments

Andrius Leonavicius 7-Apr-14 11:24am

Agree with you, +5.
One more thing to mention: select only needed columns instead of *.

Mehdi Gholam 7-Apr-14 11:48am

True, thanks Andrius!

Andrius Leonavicius 7-Apr-14 11:58am

You're welcome.

Sergey Alexandrovich Kryukov 7-Apr-14 15:14pm

Captain Obvious at work got 5.

It's a bit late but... have you seen my 1st of April publication?
Power Over IP: Testing of the First Experimental Facility.

Hope it can feel you more energetic :-) and fun; and perhaps you can ask me some difficult questions. ;-)

—SA

Maciej Los 7-Apr-14 17:41pm

Excellent answer, +5!
Please, see my answer ;)

CPallini 14-May-14 12:28pm

5.

Mehdi Gholam 14-May-14 12:40pm

Thanks!