Ludvig Strigeus uttered:
Assuming I have an autovacuum database that primarily stores 32k blobs. If I
add/remove lots of rows, will this lead to excessive fragmentation of the
overflow chains, or does Sqlite do anything to try to unfragment the pages
belonging to a single row?
I believe auto-vacuum will simply shuffle data so as to compact free
space, rather than ordering table and overflow data into contiguous
regions. Hence, you'll still have fragmentation.
Thanks,
Ludvig
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
