Re: items pictures in DB

Article View: borland.public.interbase.sql

Article #394

Back to borland.public.interbase.sql Previous Next

#394

From: WillR
Date: Tue, 13 May 2008 15:41

41 lines
1821 bytes

Safwan wrote:
> Hi
> 
> I want to store items pictures in the database. I create a table with blob 
> field like bellow.
> I have about 4000 item.  Every item picture is 350x250 and about 14KB to 
> 50KB.
> 
> CREATE TABLE ITEM_PICS
> (
> ITEM_ID VARCHAR30 NOT NULL,
> ITEM_PIC BLOB SUB_TYPE 0 SEGMENT SIZE 80
> .
> 
> 
> Is  ( ITEM_PIC BLOB SUB_TYPE 0 SEGMENT SIZE 80 ) suitable for that pictures 
> ??
> 
> What about performance in Selecting and network 10/100 ??
> 
> What about database size ??
> 
> Is there any recommendation or advices ?
> 
> Thanks. 
> 
> 

I am doing this on 10/100 and 1GN lans -- it seems ok.

Get a copy of the ImagEn library from HiComponents.

It will lighten your work load.
http://www.hi-components.com/nindex.asp

You can store jpegs making the images more compact.


-- 
Will R
PMC Consulting

Technical Details

Message-ID: <4829b687$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.isoc.lu!newsgroups.borland.com!not-for-mail

References: <48295505@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,d89db6a4d21e5b3c
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 13 May 2008 09:41:14 -0600
From: WillR <willrNo.Spam.pmccl.noSpam.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: items pictures in DB
References: <48295505@newsgroups.borland.com>
In-Reply-To: <48295505@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 189.174.196.62
Message-ID: <4829b687$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1210693255 189.174.196.62 (13 May 2008 08:40:55 -0700)
Lines: 41
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.isoc.lu!newsgroups.borland.com!not-for-mail

Reply to Parent Message