1

I am making cache table for website. It will have no problem with indexes (one unique index, simple quires), but it will have a lot of utf text. It will be 10-15gb (2 mln rows). Caching will help a lot for saving cpu usage, without cache every page has many complex queries.

Is it ok two have such a big table? It will be queried only with "SELECT text WHERE id = $id" several times a second.

1 Answer 1

0

MySQL itself can handle primary key selects very efficiently. However cached content does not require transactional engine so it would be much faster to store this kind of data in various key-value storages. Memcached is the first one to consider.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.