in reply to Re: Simultaneous access to the tk script
in thread Simultaneous access to the tk script

SQLite may support limited concurrent access, but it is intended to be embedded. Better switch to a "real" database...

Hi,

SQLite is intended for uses it can handle, and this seems exactly like one of those uses.

a simple transaction consisting of a random select and a random update... 4000 transaction s per-second (TPS) scaling well up to 100 connections, whereas SQLite remains constant at 500 TPS, about one-tenth the performance of BDB

  • Comment on Re^2: Simultaneous access to the tk script