Remix.run Logo
▲ creatonez 2 hours ago

Is the CGI process opening up the SQLite database for every request...? That would have the most insane contention ever.

▲zbentley 2 hours ago | parent [-]

Would it? The file handle doesn’t contend for a lock IIRC; just writes.

▲creatonez 2 hours ago | parent [-]

I mean sure, you could still win if almost no requests are opening the database in write mode

▲zbentley 44 minutes ago | parent [-]

Does it lock if the DB is opened in write mode, or only when a write query is issued?

If the latter, then it’ll only contend on simultaneous writes, which mutex anyway.