Comment Comment by brentroose Almost all, actually. I wrote about it here: https://stitcher.io/blog/11-million-rows-in-secondsA couple of things I did:- Cursor based pagination - Combining insert statements - Using database transactions to prevent fsync calls - Moving calculations from the database to PHP - Avoiding serialization where possible parent brentroose 8 months ago
A couple of things I did:
- Cursor based pagination - Combining insert statements - Using database transactions to prevent fsync calls - Moving calculations from the database to PHP - Avoiding serialization where possible