Hello Everyone, I am designing an IP Routing Software. Work arrives via telnet clients or routing control packets. I am planning to use the POSIX select function to handle all work in a single loop in one thread. I will have one SQLite memory connection for my routing tables. When a user starts a query into one of the routing tables the telnet socket will block on a write. So when other work arrives via the select function my SQLite connection is in a middle of a query. I can not use my database connection any more until the blocked query is done. I don't want to abort the query. I looked into the shared cache mode a bit but I am not sure if this is the answer. Is it possible to break a querie into multiple SQLite compilations.
Thanks, -Alex _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
