Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-10-12 : 01:29:27
|
| Dear Experts,i've one table named table11. in this perticular table, i've 30 columns and 40,000 rows of data.this table is taking 35 sec for select * from table11.defnetly it will take more time if i used this in some places like procedures and functions or views like that.where is the problem? generally it takes that much of time or is there any problem?guidence please.....VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-12 : 02:22:10
|
| Why do you want to do SELECT * from a table of 40,000 rows? I don't think the user is going to read them all! But all you are looking at is the time to retrieve that data from the server, not the time for the server to prepare that data.Worry about tests that represent your actual applicationKristen |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-12 : 03:40:10
|
| If you don't need to read them all , you could consider adding a WHERE clause with relevant indices , this could speed this upJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-12 : 04:40:25
|
Which columns are relevant for each query?I doubt you need all 30 columns for every query against this table.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-10-12 : 09:46:33
|
| from this table, only 10 columns are having that much data...all the other columns are having some default data only.....i've to use this table at so many places...VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
Time taking table