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”