How much is cached

o the database that select out the contents of a BLOB, will the BLOB be read only once (and found in cache the other time), or will it be read from disk twice? Best regards, Mads Kristensen [1] http://fuse.sf.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Amount of data stored in a blob

Ok. I am replying to my own post here ;-) I guess that the reason is the fact that only 2 bytes are reserved for storing the size of the BLOB, and since an unsigned short's maximum value is 2^16-1 this is also the maximum size of the BLOB. So, mystery solved :-) - Mads Mads Kristensen wrot

Amount of data stored in a blob

curious ;-) Best regards, Mads Kristensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL C API questions

eason that I ask this question is that if the fields are not zero-terminated I have to copy the values into a temporary buffer, zero-terminate that buffer and the do the conversion every time... This seems like a lot of wasted work ;-) Best regards, Mads Kristensen -- MySQL General Mailing List For

Re: B-tree index question

*snip* > Yes. > B-tree is always balanced: http://www.nist.gov/dads/HTML/btree.html > > Regards, > Sergei *snip* You are right, B+Trees are always balanced but When you insert in increasing order all your inserts will be to the last leaf of the B+tree. This means that you can get some concurr