Hi, ALL, I am developing my application on Windows using MSVC 2010 32-bit and test on Win 7 64-bit. Recently I had to create a trigger (actually 2 triggers to populate data in 2 tables). After those triggers had been created the application start-up time significantly increased (debug version under MSVC debugger). It now takes couple of second to start.
On start-up it opens connection to the database and queries the table that is not part of the trigger. The query on start-up is (pseudo-code): SELECT a, b, c FROM foo; Trigger code is (pseudo-code): CREATE TRIGGER bar_insert AFTER INSERT on bar BEGIN UPDATE bar.... END; SQLite version is 3.7.14 and is compiled from source. If the debug start-up is now takes couple of second then the release version will be slower as well. Any idea what to look for? Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
