On Wed, Nov 13, 2013 at 12:20:42AM +0000, Walter Hurry scratched on the wall:
> 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.


  "Normalize 'til it hurts.  Denormalize 'til it works."

  (and in that order!)

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to