On Feb 7, 2011, at 4:26 PM, Yuzem wrote: > > I have many movies by tag and many tables like "tags" (keywords, countries, > languages, genres, etc..)
Hey... sounds like IMdb :P > This solution implies one additional table and two triggers by each table. To paraphrase: Some people, when confronted with a problem, think “I know, I'll use triggers.” Now they have two problems. In any case, as mentioned by Michael Black, you might benefit greatly by normalizing your table and indexing the foreign key: http://dev.alt.textdrive.com/browser/IMDB/IMDB.ddl#L401 Don't bother with the triggers. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
