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 |
|
spm
Starting Member
1 Post |
 Posted - 2007-05-05 : 05:06:07
|
| Hi All, I have a simple sql query which fetches all the data from a table (select * from table_name), the query does not have 'where' or 'order by' clause. The time taken to display data from a table with 80000 records and 18 columns in management studio takes about 10 seconds. Is this normal, I remember trying out the similar query on msde where it took roughly around 2 sec. I am quite convinced the problem here cannot be sql express, but perhaps because of some settings. Guide me on this.Thanks in advance,spmspm |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-05-05 : 12:18:47
|
| What type of CPU/Ram configuration are you running? 8-10 seconds is not all that bad if your system is running other applicaions along w/ sql 2005. You probably have a application that's eating up your ram in the background. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-05 : 12:39:25
|
| Also check disk i/o. When you compare it with msde, should take server hadrware spec into consideration. |
|
|
|
|
|
|
Query takes long time in sql express