SQLite over a network
I have an application that runs over a network, can have up to 300 users. Currently data is stored in flat files (around 50,000 'rows' total) and I'd like to convert it to a database. Because it is so easy and integrated with AutoIT, I've been looking at using SQlite. Perhaps I should go with Mysql, though I know less about programming with that.
This is what I understand:
There may be some performance issues because of the latency of data transfer across the network.
There is a possibili
A little update on this can be useful to make a decision:
You may want to setup a handful of peecees to test how that works in practice.
To read, prefer _SQLite_GetTable[2d] over applicative loops (it's faster) and don't forget that any Read/Modify/Write transaction _absolutely_ needs to be wrapped inside
_SQLite_Exec($hdb, "begin immediate;") ; if not "begin exclusive"
and
_SQLite_Exec($hdb, "commit;")