[OpenSIPS-Devel] Enlarging xcap table doc field

Saul Ibarra Corretge saul at ag-projects.com
Fri Nov 27 13:59:07 CET 2009


> 
> In a high load environment I wouldn't like to imagine a MySQL MyISAM
> table (xcap) storing millions of rows with a MEDIUMBLOB field. Such
> kind of tables get corrupted after some time and so, for sure.
> IMHO is not a good design.
> 

No binary data gets stored, it's just text. An XML with a base64 encoded image. Do you think storing at most 16MB of text (there are size constraints for the image so i'll never get bigger than a few MBs) it could get corrupted?


-- 
Saul Ibarra Corretge
AG Projects







More information about the Devel mailing list