Petite Abeille-2 wrote: > > Hey... sounds like IMdb :P > Yes, I'm coding a http://yuzem.blogspot.com/p/figuritas-screenshots.html movie manager that grabs the info from imdb.
Petite Abeille-2 wrote: > > 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 > I thought sqlite didn't handle foreign keys correctly, I am using triggers to automatically delete tags when a movie gets deleted. If I use a foreign key will it automatically remove the tag if the movie gets deleted? Anyway, to use integers in the "tags" table is very complicated because I will have to assign the corresponding number to each tag that I insert and I have to insert lots of keywords for every movie. Does sqlite has any function to convert a text string into an unique number? -- View this message in context: http://old.nabble.com/Speed-up-count%28distinct-col%29-tp30864622p30867411.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
