Subject BLOBS-the better choice?
Author Rolf Bredemeier
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