On Tue, 12 Nov 2013 17:47:05 -0500, jose isaias cabrera wrote: > I am trying to speed up our queries and normalize our DB and I am > reading, > > http://www.sqlite.org/eqp.html > > But, I am missing a lot. Where do I read about the results and how to > make changes to the DB to speed up/enhance the DB response? Thanks. > Normalize first. Then work out what queries you need, and add appropriate indexes. How fast do you need it to be? If it's still not fast enough, consider denormalizing selectively, and what the overhead will be in maintaining redundant data.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users