Hacker News new | past | comments | ask | show | jobs | submit login
How To Speed Up Your MySQL Queries (ajaxline.com)
9 points by Anon84 on Feb 4, 2009 | hide | past | favorite | 3 comments



re: point 1 - I've always been told not to use persistent connections. Anybody have a link to a good article on when a persistent connection is more appropriate?


Some of these are pretty neat; I didn't know about the MEMORY (formerly HEAP) table type, but it does seem ideal for storing session data.


I miss prepared queries. They speed up repeating queries a lot.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: