Subject | Re: BLOB performance |
---|---|
Author | yuraukar |
Post date | 2005-01-24T08:17:04Z |
Thank you for the feedback. However I did not yet understand one
aspect. I was certainly not suggesting to store each BLOB in an
external file instead - this is clearly slow.
There is however the option to have more than one db file for a single
database. Would it be good (or even possible) to have blobs stored in
a dedicated db file, separate from the "normal" table data.
If one file, isn't there the danger that blob data splits normal table
data all over the file, so access to that data requires more file access?
Thanks.
Yuraukar
aspect. I was certainly not suggesting to store each BLOB in an
external file instead - this is clearly slow.
There is however the option to have more than one db file for a single
database. Would it be good (or even possible) to have blobs stored in
a dedicated db file, separate from the "normal" table data.
If one file, isn't there the danger that blob data splits normal table
data all over the file, so access to that data requires more file access?
Thanks.
Yuraukar