"Matthew L. Creech" wrote
in message
news:5ee96a840904271946o315df05dxb45024d5c0474...@mail.gmail.com...
> On Mon, Apr 27, 2009 at 10:25 PM, liubin liu
> <7101227-k+ct0dcb...@public.gmane.org> wrote:
>>
>> thanks
>>
>> I'm not sure of the real reason.
>> It's true that the speed of inserting wi
"Matthew L. Creech" wrote
in message
news:5ee96a840904271946o315df05dxb45024d5c0474...@mail.gmail.com...
> On Mon, Apr 27, 2009 at 10:25 PM, liubin liu
> <7101227-k+ct0dcb...@public.gmane.org> wrote:
>>
>> thanks
>>
>> I'm not sure of the real reason.
>> It's true that the speed of inserting with
"Matthew L. Creech" wrote
in message
news:5ee96a840904271946o315df05dxb45024d5c0474...@mail.gmail.com...
> On Mon, Apr 27, 2009 at 10:25 PM, liubin liu
> <7101227-k+ct0dcb...@public.gmane.org> wrote:
>>
>> thanks
>>
>> I'm not sure of the real reason.
>> It's true that the speed of inserting with
"Matthew L. Creech" wrote
in message
news:5ee96a840904271946o315df05dxb45024d5c0474...@mail.gmail.com...
> On Mon, Apr 27, 2009 at 10:25 PM, liubin liu
> <7101227-k+ct0dcb...@public.gmane.org> wrote:
>>
>> thanks
>>
>> I'm not sure of the real reason.
>> It's true that the speed of inserting with
On Tue, Apr 28, 2009 at 3:25 AM, liubin liu <7101...@sina.com> wrote:
>
> Thanks!
>
> It sounds pretty good. But I don't understand it exactly. Could you write
> down the sample codes?
>
Please see the documentation here:
http://sqlite.org/c3ref/funclist.html
You'll have something along the line
Thanks!
It sounds pretty good. But I don't understand it exactly. Could you write
down the sample codes?
Matthew L. Creech wrote:
>
> On Mon, Apr 27, 2009 at 10:25 PM, liubin liu <7101...@sina.com> wrote:
>>
>> thanks
>>
>> I'm not sure of the real reason.
>> It's true that the speed of inser
On Mon, Apr 27, 2009 at 10:25 PM, liubin liu <7101...@sina.com> wrote:
>
> thanks
>
> I'm not sure of the real reason.
> It's true that the speed of inserting with transaction is very fast. But my
> project is using SQLite mainly in selecting something. I don't know how to
> use transaction in the
thanks
I'm not sure of the real reason.
It's true that the speed of inserting with transaction is very fast. But my
project is using SQLite mainly in selecting something. I don't know how to
use transaction in the situation. May some friends give me some codes on
that?
My application needs some
P Kishor wrote:
> On Fri, Apr 24, 2009 at 5:27 AM, John Stanton wrote:
>
>> Sqlte provides COMMIT and ROLLBACK unlike Berkeley. If you can get by
>> without the advanced features of Sqlite, then use Berkely and take
>> advantage of its simplicity and faster execution.
>>
>
> BDB does supp
On Fri, Apr 24, 2009 at 5:27 AM, John Stanton wrote:
> Sqlte provides COMMIT and ROLLBACK unlike Berkeley. If you can get by
> without the advanced features of Sqlite, then use Berkely and take
> advantage of its simplicity and faster execution.
BDB does support transactions...
http://www.oracl
Sqlte provides COMMIT and ROLLBACK unlike Berkeley. If you can get by
without the advanced features of Sqlite, then use Berkely and take
advantage of its simplicity and faster execution.
Note that for best performance an Sqlite application should group
database inserts, deletes and updates int
Thanks
I amend the code according to your message.
Marcus Grimm wrote:
>
> in your test code I see that you open the sqlite DB
> each time you perform the single query.
> I guess it would be fair to open the sqlite DB only once
> outside your test loop.
> 2nd: You query against ID without an i
in your test code I see that you open the sqlite DB
each time you perform the single query.
I guess it would be fair to open the sqlite DB only once
outside your test loop.
2nd: You query against ID without an index, try either
define an index on ID or change your table definition
into "ID INTEGER
Hi,
On Fri, Apr 24, 2009 at 11:35 AM, liubin liu <7101...@sina.com> wrote:
>
> our project is using sqlite3, but found that the speed is too slow.
> I just tested the BerkeleyDB, and found that the speed is very fast. But I
> knew the sqlite3 is fast enough. And so I'm confused.
> I may be using s
101...@sina.com>
Date: Friday, April 24, 2009 9:05 am
Subject: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley
db, I'm confused
To: sqlite-users@sqlite.org
>
> our project is using sqlite3, but found that the speed is too slow.
> I just tested the BerkeleyDB, and fou
our project is using sqlite3, but found that the speed is too slow.
I just tested the BerkeleyDB, and found that the speed is very fast. But I
knew the sqlite3 is fast enough. And so I'm confused.
I may be using sqlite3 in wrong way?
anyway, next is my test code. I'm glad to receive your message.
16 matches
Mail list logo