> Instead of keeping your total in abcCount, make another table > especially for counts > > countType number > abc 27 > def 14 > > and use the TRIGGER to update that table.
I could do that, but I still don't know when to update abc and when to update def, based on the value being inserted. > But for counts you don't need to do that, since there's an aggregate > function for counting in SQLite. It's too slow unfortunately (when we get to hundreds of thousands or millions of records). Thanks, Dennis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
