On Sep 24, 2008, at 1:13 AM, Alex Scotti wrote: > > On Sep 23, 2008, at 2:35 PM, Jay A. Kreibich wrote: > > >> >> It doesn't "blatantly" anything. Indexes are outside of the >> Relational Model and have nothing to do with it. They're >> orthogonal. >> From that, anything having to do with creating, using, or >> manipulating indexes is outside the model. >> >> Within any actual real-world RDBMS product, however, once you >> accept >> the need for indexes (on any level) then it shouldn't be hard to >> accept the desire to control how those indexes are used. > > no. no no no. i don't know how to convince you of this deep > mistake other than beating you over the head with your own words. > > > as i said, i give up. > > at the point where the conversations look this, i begin to worry: > > question: "my query runs very slowly! i don't understand why!?" > answer: "just append this glob of sqlite specific crud to your > query and it runs great!" > > question: "this query runs slow also!" > answer: "just code in raw vdbe instructions, you'll have absolute > control over the choice of index usage!" > > question: "this query runs slowly still!!" > answer: you should be using berkeley db. they give you absolute > control over everything. > >
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users