Hi Rolf,

i think, it will make no difference, since blobs are always stored outside of
the table. There´s just a reference to it in the main table.

Harald

Rolf Bredemeier wrote:

> Hi all!
>
> Perhaps someone can show me the right way:
>
> For our CAD-DB i have a table with some integer,date and varchar(50) fields.
> And, too, a BLOB-field for a thumbnail - image.
> The image size of the thumbnails is between 4 and 7 k.
>
> Is it the better choice to redesign my table and to put the BLOB in a
> seperate table? Only with an additional field to link the thumbnail to the
> master table?
>
> What better for performance? Or is it the same?
>
> To get more speed, i have increased the PAGESIZE of my database from 4096 to 8192
> That was a bad idea, selecting data now much, much slower than before.
>
> Best regards,
>
> Rolf
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/