Trying to strip down and optimize a MYSQL proccess. Written in VBStudio classic using simple enough SQL a couple of joins etc.
Looking to speed up this process as much as poss, have looked at indexes and used EXPLAIN to check them, and incresed the table_cache and max_connections etc. which helped but not enough.
If ne one has ne ideas or a link to a good resource for MYSQL optimization it would be much appriciated.
+ if ne one has links to a good vb resource aimed specificly at good SQL programming practices and optimization.