Posted by news.tele.dk on 11/13/06 18:04

Hi

We have a SQL server 2000 SP4 on a windows 2003 2x3Ghz XEON 4 GB ram.

We have a table looking like this with currently 6 rows. Total data is aprox
10 kb i all row all together.

CREATE TABLE [dbo].[BIOMETRICPROFILE] (
[BIOMETRICPROFILEID] [bigint] IDENTITY (1, 1) NOT NULL ,
[FINGERPRINTTEMPLATE1] [image] NOT NULL ,
[FINGERPRINTTEMPLATE2] [image] NOT NULL ,
[FINGERPRINTTEMPLATE3] [image] NOT NULL ,
[FINGERPRINTTEMPLATE4] [image] NOT NULL ,
[FINGERPRINTTEMPLATE5] [image] NOT NULL ,
[FINGERPRINTTEMPLATE6] [image] NOT NULL ,
[TYPE] [nvarchar] (50) COLLATE Danish_Norwegian_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

select * from BIOMETRICPROFILE takes ~4 seconds (!) to execute thourgh Query
analyzer. Alle other tables has no performance problems.

We have a SQL 2005 express instalation on the same server. If we restore a
backup from the sql 2000 database the query takes aprox ~ 15 ms.What is
going on here?

Has SQL 2000 problems with image fields? or how can we find the problem?

Regards
Anders

• Next in forum: Re: SQL 2005 & Login Triggers?
• Prev in forum: Re: Please Help With Complex Update Statement Logic
• Thread view: SLOW performance on table with image fields (SQL 2000)

[Reply to this message]