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
Handling large data with cron jobs and queue workers
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”
Using MySQL to return complex tagged results
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, …
Model Search and Filtering in Laravel
Hi guys, as I have written this functionality a few times at this point, and I have been asked how to do it a couple of times, too. That is Laravel searching and filtering, I am going to develop a simple composer package which I can use to allow users to search and filter Laravel …
An introduction to Checksums
Hi everyone This is a quick introduction into checksums, and practically how to use them, at the request of someone through the Ask Johno section of the blog. I know what a checksum is, but I’m not sure how to implement or use one (in PHP) to achieve what I need. Anonymous Asker They go …