Posted by news.tele.dk on 11/15/06 17:39

Your answere indicates that the image type is "randomly large" so to much
data is retrieved. Is image the wrong field type then? My binary data is
beteween 1-200kb large per field but the current performance is not an
option.

And why is sql 2005 working whitout problems?

Can you please give me some more details. Thanks in regards

Anders

"Ed Murphy" <emurphy42@socal.rr.com> skrev i en meddelelse
news:MuH6h.706$Fg.524@tornado.socal.rr.com...
> news.tele.dk wrote:
>
>> 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
>
> http://www.catb.org/jargon/html/Z/Zero-One-Infinity-Rule.html

[Back to original message]