Hi all,

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.

Cheers

I think your keyboard is broken.

Thnx real helpful