Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

"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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

"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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

"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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

"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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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. >>

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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 found

[sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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