I’ve been developing a system for a while now and it’s currently in the testing stage, I noticed that a SQL injection vulnerability had crept in. I was quite surprised because my filtering methods are generally quite good and I’ve not seen any SQL errors in the logs for quite some time. Luckly the site [...]
Continuing from my earlier post on PHP performance, I thought I’d share a few Mysql tips that I’ve learnt over the years. Hope it helps someone and please leave a comment with your own tips or provide any corrections to the ones mentioned.
Word searching
1.
SELECT * FROM TABLE WHERE MATCH (`field`) AGAINST (’Keyword’)
(Fastest)
2.
SELECT * FROM TABLE [...]
Mysql Caching
I’ve been modifying a large insurance database system recently for a big client and I have encountered a few performance problems with mysql. I have been messing around with my.cnf for quite a while and I think I’ve been able to significantly increase performance of repeated queries.
Now the problem is that the current database [...]