On Thursday, November 8, 2012, Peter Haworth wrote: > Yes, but keep in mind that the whole database is locked for the duration of > the transaction so if you have a long operation going on by one user, your > other users will have to wait a while.
That should be livable, I think. the foreground is fairly small transactions (either a single row with something like 50 columns, or a couple of dozen rows with half a dozen columns). the background would be a periodic sync with the remote cloud database, so also fairly small. thank you. but it still sounds like I would be better off using the built-in PostgreSQL on Mac, and preferring that MySQL or PostgreSQL be installed on windows & Linux. > This includes readers will some > sort of write operation is going on. There is a newer type of locking > called WAL (write ahead locking) that does permit reads while write > operations are in progress but the version of the sqlite library in LC is > too old to have that available. > Hmm, I don't suppose that I could compile and include with/in my standalones in any practical manner? -- Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
