Re: [sqlite] Slow Sqlite3 Select Query while Insert/Update/Delete has no issue

On Mon, Sep 19, 2016 at 4:56 PM, James K. Lowden wrote: > On Wed, 14 Sep 2016 16:27:37 +0530 > > But I agree with Teg: SQLite is providing you with transactions you > don't need, and puts an interpreted language exactly where you don't > want it: in a

Re: [sqlite] Slow Sqlite3 Select Query while Insert/Update/Delete has no issue

On Wed, 14 Sep 2016 16:27:37 +0530 SinhaK wrote: > strlen(MyString.str().c_str()) BTW, as a matter of style, MyString.str().size() gets you to the same place sooner. > MyString<<"select TokenNo,Price ,sum(QTY) from 'Stream0' where > TokenNo=?1 and

Re: [sqlite] Slow Sqlite3 Select Query while Insert/Update/Delete has no issue

Hello SinhaK, >>I decided to use sqlite3 in c++ after reading a lot about its >>performance. If it's purely in memory, I question why you're using Sqlite in the first place. I'd use in memory data structures like a hash set or multi-map instead. Sqlite is great and I use it a bunch but

Re: [sqlite] Slow Sqlite3 Select Query while Insert/Update/Delete has no issue

On 14 Sep 2016, at 11:57am, SinhaK wrote: > create table 'Stream0' ( TokenNo int NOT NULL,OrderId integer NOT NULL,SIDE > int NOT NULL,PRICE int NOT NULL,QTY int NOT NULL,PRIMARY KEY (OrderId)); > > Index On Table : > > CREATE INDEX DataFilterIndex ON

[sqlite] Slow Sqlite3 Select Query while Insert/Update/Delete has no issue

I am stuck in a issue related to slow sqlite3 select. I have searched a lot on this forum and have applied many of the suggestion which has somewhere helped me in moving ahead. I assume there are some fault in the way i am trying to use sqlite or may be the settings which i have used while