| Author |
Topic |
|
Sivangari
Starting Member
16 Posts |
 Posted - 2010-08-23 : 10:23:11
|
| i have a table with 40,000 records.Need to retrieve 40,000 data at a single select with good performance.Please help me out. how to select those records. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-23 : 12:56:22
|
| you need to select all the columns or selected ones?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sivangari
Starting Member
16 Posts |
Posted - 2010-08-24 : 00:27:52
|
| Need to select all the column.Good Performance means,while selecting and displaying in front end the application was very slow.It take a long time to show the data.I need to show all the data in good performance . |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-08-24 : 03:38:28
|
quote:
Originally posted by Sivangari
Need to select all the column.Good Performance means,while selecting and displaying in front end the application was very slow.It take a long time to show the data.I need to show all the data in good performance .
Which front end are you using?If you use VB/VB.NET, you can directly bind the result to a grid that would be faster than looping all the rowsMadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sivangari
Starting Member
16 Posts |
Posted - 2010-08-24 : 05:02:13
|
| That is not .net application.Java application and no controls to show the data there.Just will display all the record at a fetch. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-08-24 : 05:05:55
|
quote:
Originally posted by Sivangari
That is not .net application.Java application and no controls to show the data there.Just will display all the record at a fetch.
If you are retreiving data one by one, there will be performance issuesMadhivananFailing to plan is Planning to fail |
|
|
|
Sivangari
Starting Member
16 Posts |
Posted - 2010-08-24 : 05:07:54
|
| So,only i am asking is there any way to avoid this performance issue and the data also should be available in a speed manner |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-08-24 : 05:11:06
|
quote:
Originally posted by Sivangari
So,only i am asking is there any way to avoid this performance issue and the data also should be available in a speed manner
If you are showing data in a table, use pagination method. Search for the same in Google/BingMadhivananFailing to plan is Planning to fail |
|
|
|
|
need to retreive a bulk of data
MadhivananFailing to plan is Planning to fail 
It seems to be an application issue and not a database issue, but I'm waiting around until they say it has been resolved.Tara Kizer