- they use indexes
- they have *a lot* of RAM to serve all that.
- they are likely not using sqlite, but a real sgbd like MariaDB or PostgreSQL
@vincib Additionally, they may also split their data in chunks to be handled by different worker nodes? (just a guess)
@vincib Adding an index to the sqlite database --> the result of a data at row 3,500,000 is instant, thanks for the tip!
Mamot.fr est une serveur Mastodon francophone, géré par La Quadrautre du Net.