Categories
JavaScript Performance Web

Don’t mistake the service worker as a small thing

Service workers let you decide what a user experiences on your website when there is, is not or is limited network connectivity. The service worker is a game-changer. It is no small thing; not because we can make web applications work offline but because we can fully control how our web application access the network. […]

Categories
JavaScript Performance Web

The JavaScript Event Loop

I received that feeling of excitement, the unlocking of the mind, watching Philip Roberts unpack the JavaScript event loop at JSConf EU 2014. I’d like to share that moment and hopefully the feeling. Who knew setTimeout(function(){ do_stuff(); }, 0); would be so helpful.

Categories
Performance PHP SQL Web

Raw PHP and MySQL Eager Loading

Working with complicated and joined data sets can be tricky for MySQL database performance. For example, What if you need to load multiple authors and their books from a database. How would you work around the N+1 problem and avoid unnecessary queries to the database without an expensive join statement? The answer is quite simple. […]

Categories
Performance SQL Web

Enabling Performance Monitoring for MariaDB and MySQL

Enabling performance monitoring for MariaDB and MySQL works the same way. Performance monitoring for databases is beneficial when you have records in the hundreds of thousands using complex joins. It also helps when you want to do essential performance monitoring overall. In the past, you could use general_log, log_slow_queries and SHOW PROFILES. Since MySQL 5.5 […]