Archive: performance

Just came across this forum post of MySQL that looks to be a gold mine of information related to performance tuning MySQL. For reference I am copying and pasting the full thing here though all credit goes to the above. Book: High Performance MySQL (2nd Edition) http://www.highperfmysql.com/ MySQL Performance Tuning – Best Practices: http://jpipes.com/presentations/perf_tuning_best_practices.pdf MySQL [...]

If you need to update a large number of rows on a single table then your first reaction may be to write a loop that updates one row at a time. Of course if the table is large then this can result in a very large number of SQL queries. Taking a bit of inspiration [...]

If you are looking to gain the most out of your Magento hosting and to optimise your Magento hosting stack, here are a few top tips that you can try. 1. Ensure Caching is Enabled It may sound obvious, but if you do not have caching enabled then the performance of your Magento store is [...]

Edmonds Commerce have been with Magento since the beginning. If you would like us to optimise your VPS or dedicated server for Magento then please get in touch today. Back then the speed of Magento was one of its main drawbacks. Since that time, the code has improved a lot and things have generally got [...]

If you dig a little deeper into Magento you will notice that there is a fully featured caching system lurking in there. However, as standard, it is quite under utilized. I'm sure that the primary reason for this is that caching dynamic systems can cause admin user confusion and generally make things trickier. However all [...]

If you are finding iPlayer or Youtube videos are using excessive amounts of CPU, it might be worth trying this fix Simply create a folder in /etc called adobe (assuming it doesn't already exist) PLAIN TEXT CODE: sudo mkdir /etc/adobe now create a file called mms.cfg with this single line in it: PLAIN TEXT CODE: [...]

If you use Zend_Db_Statements directly as well as using the Zend_Db_Table family of classes for Active Record et al then you might find the following little tip useful. By default, if you run a query using something like PLAIN TEXT PHP: public function query($sql, $params=false) {     if(empty($params)) {         $stmt [...]

osCommerce is a great ecommerce package which is hugely popular due to its full feature set, massive options for customisation and a huge support base. However if you want to run a large catalogue, or have plenty of visitors then speed can become an issue. There are a number of things you should look at [...]