Re: blob vs. many columns
> the overhead is huge
Wrong. The fetching of a row takes orders of magnitude more work than the details of the fields fetched.
Furthermore, MySQL can probably fetch one blob a lot faster than 100 FLOATs.
Furthermore, the BLOB is likely to take less space than the 100 FLOATs. If that is the case, the savings in I/O time is far more than the CPU time lost.
Do not worry about CPU time at the cell level.
Subject
Written By
Posted
Re: blob vs. many columns
July 06, 2012 12:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.