Retrieving 3+ million MySQL records, in less than 2 minutes
Looking at how I modified a SQL query to retrieve 3.2 million records from a database (paginated) in about 10% of the time of a traditional paginated query
Looking at how I modified a SQL query to retrieve 3.2 million records from a database (paginated) in about 10% of the time of a traditional paginated query
One problem a lot of developers seem to come into, from reading their code, is when they try to handle large sets of data with background scripts. There are a few common mistakes that I have seen from inheriting the code of my predecessors, and I thought I would offer some solutions to the problems …
Read more “Handling large data with cron jobs and queue workers”
In this article I cover some of the things that I have learned over the years
In this article I cover some of the basics of the kinds of considerations you might have when considering moving from VPS/bare metal server into cloud architecture.
Hi everyone In this article I thought I would tackle complex tag searching, using MySQL. There are lots of ways this can be achieved at a PHP level, through looping and checking/comparing. However, if you are working with a large dataset, and tagging is a required piece of functionality, for example in an enterprise blog, …