logo
Aug
11
Marijan Šuflaj

Sql Queries Cache

This will be intermediate tutorial about caching SQL query results. We will use interface to make support for extending available ways of caching your results. We will create cache that will use MySQL database and flat text files to store cache.

Read the rest

Jul
27
Marijan Šuflaj

MySQL Quite Complex Queries

I’ve read an article about database design. It’s very simple but I try to design my databases/tables following that article. But there is one thing that is also important. You need to design your tables and their relations so that you can get almost everything your need with as much queries as possible. This is a part that MySQL-s complex queries are very useful. In two last jobs that I did I needed to optimize script as much as possible. One project is a plugin for Wordpress that I’m currently working on. When ever I do something I give my best to do it right and I really try to design relations and queries very good. Here are some examples of queries that I needed.

Read the rest

logo
Powered by Wordpress | Designed by Elegant Themes | CopyRight ©2010 php4every1.com