Keith...as a neophyte, I am totally blown away by your skill level in SQL and the ease with which you explain its underlying operations. I am extremly impressed by the 'flattening of the query' and its operation...it worked perfectly!!.
I am so happy that this forum has persons of your caliber who totally understands SQL and can provide efficient solutions to problems forum members, like myself, may have. Again, thanks and be well. > Subject: RE: [sqlite] What am I doing wrong? > Date: Fri, 8 Aug 2014 17:40:28 -0600 > From: [email protected] > To: [email protected] > CC: [email protected] > > > Leaving out the extra fields the movie table, enforcing referential > integrity, and using "same column names" to hold the same data, and declaring > the right indexes, you can get a much more efficient solution, both in the > expression and the execution: > > These optimizations are only necessary *after* you have solved the problem, > and then really only if performance is inadequate. Enforcement of > referential integrity and ensuring good indexes should always be done, of > course. _____________________________ > >> sqlite-users mailing list > >> [email protected] > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
