Hello, I'm wondering if there is anything like PL/SQL that is built into SQLite? I have an application that requires me to use EXCLUSIVE transactions as follows:
BEGIN EXCLUSIVE SELECT from table limit 20 for each UPDATE record assignment COMMIT The requests for assignments are coming in concurrently from many clients and I'm finding that SQLite isn't keeping up. I know that SQLite isn't intended for highly concurrent environments that make many writes to the database, but I'd like to make it work if possible... So, is there a way to push this processing over to SQLite (e.g. PL/SQL style) that would speed it up? Or, is there some way you can think of to make assignments of a subset of records to concurrent clients that would be more efficient and help me avoid the large number of timeouts I'm getting right now? Thanks, Daniel _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
