Many small queries are efficient in SQLite

Re:Many small queries are efficient in SQLite by AtlasBarfed on Tuesday February 16, 2021 @10:39AM (#26154860)

See what you need to do is stand up a Redis cache cluster in front of your app, and then a cassandra cluster to cache the writes and compact them, before synchronizing the data with your single-page SQLite datastore as the master data.

Obviously for your SQL queries we crank up a large SparkSQL cluster.

- AWS architects

You can thank me later.

[ Parent | on HN ]

Re:Many small queries are efficient in SQLite by mekster on Wednesday February 17, 2021 @12:35PM (#26169013)

Do you get more thanks than just telling people to use MySQL than your 3 layer complicated solution?

[ Parent | on HN ]

Re:Many small queries are efficient in SQLite by quietbritishjim on Thursday February 18, 2021 @04:36PM (#26185977)

I'm sure they were being sarcastic.

[ Parent | on HN ]