Posted by Hugo Kornelis on 11/18/05 01:24

On 17 Nov 2005 06:21:22 -0800, JeremiahOSullivan@gmail.com wrote:

>Hi,
>
>I have a sql server database with 1.7 million records in a table, with
>about 30 fields
>
>When I run select * from tablename it can take over 5 minutes.
>
>How can I get this time down or is it normal?

Hi Jerry,

1.7 million rows of 30 columns each is a lot of data. The performance
might well be limited by the network capacity or by the processing that
the client does on the data.

Does the client really need all these rows? Try to refine your query -
send only those columns and those rows across the network that the
client actually needs. Pre-aggregate at the server if the client will
only use aggregates.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

• Next in forum: Re: Log Invalidated after truncate table
• Prev in forum: Re: Inner join weirdness in DTS
• Thread view: Re: Query returning 1.7million records slow

[Reply to this message]