I'm dealing with blobs of up to - I estimate - about 100 kilo bytes in size. The data is compressed already.
Depolama motoru: MySQL 5.1 InnoDB
Frontend: PHP (uskur ORM ile Symfony)
Bazı sorular:
I've read somewhere that it's not good to update blobs, because it leads to reallocation, fragmentation, and thus bad performance. Is that true? Any reference on this?
Initially the blobs get constructed by appending data chunks. Each chunk is up to 16 kilo bytes in size. Is it more efficient to use a separate chunk table instead, for example with fields as below?
parent_id, position, chunk
Ardından, tüm blob almak için, bir gibi bir şey yapardı:
SELECT GROUP_CONCAT(chunk ORDER BY position) FROM chunks WHERE parent_id = 187
Sonuç bir PHP komut dosyası kullanılabilir olacaktır.
Is there any difference between the types of blobs, aside from the size needed for meta data, which should be negligible.