Folks,
Couple of questions we were wrestling with:
1. How to tune performance of the application that uses HTML5 DB (Sqlite under
the covers). Any general tips or suggestions e.g. is it possible to use in
memory sqlite db or attach multiple db's (some in memory dbs some regular on
disk dbs?
2. How to reduce latency/ round trips on updates? We need some kind of case /
if..then capability and as we do not seem to have stored procedures we are
using triggers on insert into a driver table e.g. Actions (action, parameters)
to drive inserts/updates/deletes on other tables. Any other tuning suggestions?
Thanks in advance,
Pete
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
