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 performance-critical spot. The C++ standard
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 Side=66 group by Price order by
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 s
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 'Stream0'(TokenNo , SIDE, Price,Qty);
>
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 comp
5 matches
Mail list logo