MySQL Connector/NET and Entity Framework
How to let MySQL Connector/NET, ASP.NET and Entity Framework play nicely. Set up and check your Web.config website configuration
Cache MySQL query results with PHP WinCache
You can cache and store the MySQL query result in your web server RAM memory, utilizing PHP WinCache. Or another PHP opcode cache like Opcache for that matter. This’ll increase database and PHP performance.
Calculate MySQL database size with PHP (off the old shelf)
Calculate the MySQL database size in PHP. Sometimes you’d be amazed what you find … Read More
WordPress HyperDB is an advanced database class that supports replication
HyperDB database class. HyperDB: an advanced database class for WordPress, that supports replication and … Read More
Umbraco CMS admin password reset
If you forgot your Umbraco admin password, use the following SQL query to reset your Umbraco admin password in SQL Server Management Studio (SSMS) or MySQL
MySQL query caching using PHP/Zend_Cache
By using the Cache.php PHP class of the Zend Framework, you can relatively easy cache MySQL query results to disk. This ensures faster consecutive results and speeds up execution. In this context, caching means: execute a MySQL query once and save the result in a temporary file. For every time that same query is executed, you can simply use the result stored in your disk cache file, as long as the database hasn’t changed. Often it is faster to save this on the web server than having it to redo the query every time.