Re: BLOB/BFILE Performance

Hi,

Am 10 Jan 2005 06:26:53 -0800 schrieb <siwhy60_at_hotmail.com>:

> Hi, thanks for the reply.
>
> The reason for not putting the larger images in the db is because we
> want to keep the db size down. Storing 1/4 million 100k images in there
> would make it very large (~25Gb).
>
> What about the retrieval of those thumbnails/ images? Would the large
> number prove to be a performance issue?

The performance is determined by to steps:

1)
Finding the rowid of the row containing the blob (You should select this row through an indexed column)

2)
Download the blob
(Performance like ike downloading the same file via ftp or faster)

> Do you know anywhere I could find some statistics on all this?

Performance issues concerning lobs are discussed in the documentation (E.g: Oracle 9i lob Developers Guide (a88879.pdf), Section: "Performance")

-- 
Frank Piron,
defrankatkonaddot
(leftrotate two)