Re: Point of sale system performance issues in MYSQL

[Tod Harter]

mainly index invoicedate. 40k records isn't really a LOT of data, I'd set my key_cache to a pretty decent size to help optimize those searches as well. Make sure the way your queries and your index etc is organized works, ie use EXPLAIN and esp make sure as many as possible queries use indexes. What you probably don't want is long slow table scan SELECTS which are going to be starved by your INSERTS.

If you never do deletions you might consider using a MyISAM table as well because in that case you can have inserts and selects fully parallelized. OTOH InnoDB may work better because of finer-grained locking.