MS SQL Server - Why is sql server 2000 slow when using image columns

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Why is sql server 2000 slow when using image columns

Anderskj

2006-11-16, 7:12 pm

Hi

I have a table with columns of datatype: image. These contains aprox 16 Kb
each. When selecting the 6 rows it takes aprox. 3-5 seconds to fetch. The
same query on the same database on an sql 2005 server is instant (20 ms).

First of all. Why is sql 2000 THAT slow? It 5 rows and 100 kb data! And why
is sql 2005 much faster?

Is there a way to optimize? I guess it is because the image type is huge and
of some reason sql 2000 is fetching "to much"

The machine is a 3 Ghz xeon / 4 gb ram.

Thanks in regards
Anders

Sponsored Links