Hi,
I changed most of the primary key columns to unsigned int which are of
smaller
size than te default column sizes an result in smaller indices.
I changed some indexes to prefixed ones especially in the fof_item table
because some of them got unecessary large.
I changed the default table type to InnoDB as well, which results in less
disk reads because data and indexes can be kept in memory.
Drop me a mail if you're interested in the schema.
--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings