On 12 Nov 2013, at 10:47pm, jose isaias cabrera <cabr...@wrc.xerox.com> 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?

Create an index ideally suited to your SELECT command.  Or if your SELECT 
command involves more than one table you might be create more than one index.

How much are you trying to speed things up ?  Half the time ?  A hundredth the 
time ?

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to