Re: [sqlite] [sqlite TOO slow

ng more expensive than integer math. > >-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 the

Re: [sqlite] [sqlite TOO slow

___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Gaurav Vyas Graduate Research Assistant, Transportation Engineering University of Texas at Austin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [sqlite TOO slow

Hi, I am gonna try first creating unique index (hid, pid). It will take a bit of time and will keep you posted with the result. Thanks a lot Gaurav On Thu, Nov 24, 2011 at 2:08 AM, Simon Slavin wrote: > > On 24 Nov 2011, at 7:54am, Gaurav Vyas wrote: > > > when I do typeof

Re: [sqlite] [sqlite TOO slow

> And if it is... what's its selectivity? > > What 's the query plan? > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Gaurav Vyas G

Re: [sqlite] [sqlite TOO slow

2011, at 7:45am, Gaurav Vyas wrote: > > > I am trying to get a chunk of rows from a table which has 16 million > rows. > > The table is indexed. I am passing the query as "SELECT * FROM persons > > WHERE hid = 5;" and it takes a few minutes to get me the results. Ca

Re: [sqlite] [sqlite TOO slow

I am trying to get a chunk of rows from a table which has 16 million rows. The table is indexed. I am passing the query as "SELECT * FROM persons WHERE hid = 5;" and it takes a few minutes to get me the results. Can anyone suggest how to make it faster? Gaurav _

Re: [sqlite] SQLite: Database or disk full

t; does ? Can you try turning optimization off entirely, or to its lowest > setting ? > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- G

[sqlite] Problems with SQLite when used with MPI

Here is the situation. I am using a cluster on which you can use MPI to split the processing time on to different processors. I was using PostgreSQL but since the data was on different server than the one I am running the code, it was slowing down the simulation due to connection overhead on Postgr