By JortK on November 28, 2009
Just came across this great article with 20 best practices when using MySQL: MySQL best practices.
Be sure to check them, the following items are in the article:
Optimize Your Queries For the Query Cache
LIMIT 1 When Getting a Unique Row
Get Suggestions with PROCEDURE ANALYSE()
Prepared Statements
Split the Big DELETE or INSERT Queries
Be Careful with Persistent Connections
And more [...]
Posted in MySQL | Tagged best practices, cache, database, db, MySQL, query, select, show
By JortK on January 3, 2009
I found some cool PHP presentations, click on one of the links below the view the presentation:
Large scale PHP. – Presentation on how to handle large PHP applications.
Clustering and caching – Nice presentation on how to do clustering and caching.
Xdebug – Presentation on how to debug your PHP code using Xdebug.
PHP Best practices – Nice [...]
Posted in Tech news | Tagged best practices, caching, clustering, php, presentations, slideshow, xdebug