You must serialize a lot of data? Please try this thing:
http://opensource.dynamoid.com/
About ~2-5 months ago we compared with PHP serialize, JSON, some others and this serialize method show best rate.
You must serialize a lot of data? Please try this thing:
http://opensource.dynamoid.com/
About ~2-5 months ago we compared with PHP serialize, JSON, some others and this serialize method show best rate.
I know a lot companies in Lithuania who if need index on big table call sysadmin, but when we try to call our sysadmin to add index on big table.. that was bad idea.. because we got a lot of locked queries and after 10-30 min server was dead.
Now add index on big MySQL table is easy, just try this tool:
http://code.google.com/p/openarkkit/source/browse/trunk/openarkkit/src/oak/oak-online-alter-table.py
Example in console:
./oak-online-alter-table.py -a “DROP INDEX old_index_name, ADD INDEX ( \`OrderID index\`, \`OrderID\` )” -d database -t table -H localhost -u root –ask-pa
We try on XX GB tables, works fine! Just try it!