sage

sage's avatar
sage
laymonage_at_fosstodon.org@momostr.pink
npub153q0...fhe2
Building things up and breaking them down in the open. Indonesian in Bristol, UK. http://giscus.app, nostr:npub1apg2l5cc78ua7ax0zepgaczzhns2hj8j8c4y9knuagg8x0a3dp8qd20ejz, and nostr:npub1l0ckm3n7wc4wc7yvszs83ml76kz7lfz9hu3zwvlg3k6jlyh5j8wqytkt92 Blog: https://laymonage.com GitHub: https://github.com/laymonage Twitch: https://twitch.tv/laymonage YouTube: https://youtube.com/laymonage
Made a PR during the #DjangoConEurope sprints that could significantly improve the performance of bulk queries on SQLite 🥳
GitHub
Fixed #36143 -- Made max_query_params respect SQLITE_LIMIT_VARIABLE_NUMBER. by laymonage · Pull Request #19427 · django/django
Trac ticket number ticket-36143. @thepsalmist and I worked on this during the Djangonaut Space program, and I added the tests during the DjangoCon...
 For example, given a `bulk_create()` with 10,000 instances of a model that has 25 fields, the number of queries could go down from 251 to 1. On Debian in general, queries that originally would take N*250 batches can now be done in ~N batches. This was a ticket that one of the Djangonauts in my team worked on, then I added the tests at the sprints 🚀