My program uses a relatively slow select statement to get the rows the program needs. This is done very often, but updates, inserts and deletes are done very infrequently. My idea was to create a temporary table with the result of this select statement, then create triggers from the main table to update the temporary (or probably just drop and recreate).
I wanted to know if people thought this was a sensible approach or if there was another method which was simpler and even faster! Andrew _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
