Post: #7

Im storing large amounts of data on mysql. For example in my shard runebooks can store 128 slots, so im storing that data on sql with a table which has 32 columns. Total rows in that table is 64,941.

If you expect performance from mysql:

Sql server must in the same machine with sphere.

You need to know how to optimize tables, adding indexes. for example if you are putting 15000 player into a table, you need to index that table by uid column.

Tags are faster, but in time they are creating high memory usage and long save times. My shard consumes 432 mb ram with 870000 items. Another shard in Turkey consumes 900 mb ram with 900000 items because they are storing everything on tags, vars etc.