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 slav...@bigfraud.org wrote: On 24 Nov 2011, at 7:54am, Gaurav Vyas wrote: when I do typeof(hid

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 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. Can anyone suggest how to make it faster

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 Graduate Research Assistant, Transportation Engineering University

Re: [sqlite] SQLite: Database or disk full

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 -- Gaurav Vyas Graduate Research Assistant, Transportation

[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