January 23, 2011 at 12:21 am
Hi All,
I am a newbie here, I have a table with 600K row, assume the table name is tbsales and it have 45 columns with one primary key which its datatype is int.
when I do query from this table, where the query is "Select * from tbSales", I need 30 seconds to complete the query.
My server is Intel Xeon E7450 2.4Ghz (4 processor with 16 core), with memory 12 GB.
I use Sql server 2008 standard edition.
I already rebuild the index and update the statistic, but i still got the same result.
what i want to ask :
Is it normal to have 30 seconds just for 600K row in sql server 2008 standard edition? if not, can someone help me what i need to do to increase the performance.
Thanks.
January 23, 2011 at 12:28 am
when u dont have a WHERE clause or JOIN clause , u never are going to use to a INDEX, so ur time taken is quite normal..
January 23, 2011 at 12:43 am
i see, but when i read for some article, they said that they can query millions row in about 1 minutes.
that makes me confused, how come my table with just 600000 rows got 30 seconds.
January 23, 2011 at 1:59 am
600 000 rows is a lot of data to read off disk and send over the network.
Why 600 000 rows? What are you going to do with it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 23, 2011 at 2:00 am
Check the following things:
1. the mentioned site, did they use any where condition?
2. Are you querying from the same server or over the network?
3. Are you using the same configuration mentioned in the site?
To me, it looks normal as even you have index, never been used.
January 23, 2011 at 5:45 am
I see, I understand now.
I just want to know the performance, and just confused with other articels in web.
thanks for your reply.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply