I have a transaction log table that basically is inserting, reading, and writing new records many times a second.
It has about 5 rows with various ids in them. Aside from indexes/query modifications, is there anything specific to optimize a table like this? It's a MyISAM table type.
Thanks!