Subject | BLOBS-the better choice? |
---|---|
Author | Rolf Bredemeier |
Post date | 2001-03-12T11:51:39Z |
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
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