On Wed, 7 Aug 2013 23:13:41 +0200 Petite Abeille <petite.abei...@gmail.com> wrote:
> On Aug 7, 2013, at 9:25 PM, Christopher W. Steenwyk > <csteen...@gmail.com> wrote: > > > Ah, sorry about the attachments, you can find the files here: > > https://www.dropbox.com/l/fpFfcjwwcyhXZgduswCggb > > Ah, also, your schema has a very, hmmm, Entity?attribute?value (EAV) > smell to it (object, attribute, types, values, characteristics, > metadata, etc, etc). Most likely not helping. Most assuredly not helping, because cannot help. What it does is make your queries vague and complex, and prevent the DBMS from doing its job (because you haven't expressed the rules of the data). ANALYZE is the last step on the road to good performance. The first step is analysis! --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
