Re: [sqlite] Low Level API for SQLite3

2006-05-10 Thread Nathan Kurz
On Thu, May 11, 2006 at 10:20:26AM +0530, Anish Enos Mathew wrote: > > Dennis, >Thank you so much for sending me the code. Its works fine!! It > took 8 sec to insert 10 records into the table where previously it > was taking 30 sec to insert 1 records. Dennis, if u could do me a >

RE: [sqlite] Low Level API for SQLite3

2006-05-10 Thread Anish Enos Mathew
the code for that, can u pls send it to me... -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 09, 2006 9:33 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Low Level API for SQLite3 Anish Enos Mathew wrote: > Thank you so much cote, for ur valua

Re: [sqlite] Low Level API for SQLite3

2006-05-09 Thread Dennis Cote
Anish Enos Mathew wrote: Thank you so much cote, for ur valuable suggestion. I would be greatly thankful to u if u could send me a simple c program which uses the above API's to insert some values into the SQLite database. Anish, The sample program below shows how to use precompiled

Re: [sqlite] Low Level API for SQLite3

2006-05-09 Thread drh
Ralf Junker <[EMAIL PROTECTED]> wrote: > Is there more information available on saving and loading prepared statements > and omitting the parser from the library? > OVERVIEW The SQLite Stored Statement Extension consists of twelve source code files that are added to a standard public-domain

Re: [sqlite] Low Level API for SQLite3

2006-05-09 Thread Ralf Junker
Is there more information available on saving and loading prepared statements and omitting the parser from the library? Thanks & Regards, Ralf >the parser can be completely omitted from the SQLite library, >reducing the library footprint to as small as 60KiB. >That can be very helpful for

RE: [sqlite] Low Level API for SQLite3

2006-05-08 Thread Anish Enos Mathew
8:28 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Low Level API for SQLite3 Anish Enos Mathew wrote: > I am using sqlite_exec command for doing a particular > process in the data base. But the problem with sqlite_exec is that the > sqlite engine should parse the select or insert

Re: [sqlite] Low Level API for SQLite3

2006-05-08 Thread drh
"Anish Enos Mathew" <[EMAIL PROTECTED]> wrote: > Well, currently I am doing a mobile project and we are testing the > performance of four databases depending on the time it takes to insert > or delete or search a particular data from the database. I am using > sqlite3 database. I am using

Re: [sqlite] Low Level API for SQLite3

2006-05-08 Thread Adrian Ho
On Mon, May 08, 2006 at 04:06:33PM +1000, Bill KING wrote: > Anish Enos Mathew wrote: > > Well, currently I am doing a mobile project and we are testing the > > performance of four databases depending on the time it takes to insert > > or delete or search a particular data from the database. I am

Re: [sqlite] Low Level API for SQLite3

2006-05-08 Thread Bill KING
Anish Enos Mathew wrote: > Well, currently I am doing a mobile project and we are testing the > performance of four databases depending on the time it takes to insert > or delete or search a particular data from the database. I am using > sqlite3 database. I am using sqlite_exec command for doing

RE: [sqlite] Low Level API for SQLite3

2006-05-07 Thread Anish Enos Mathew
@sqlite.org Subject: Re: [sqlite] Low Level API for SQLite3 Anish Enos Mathew wrote: > Ya, I know about the API's given in sqlite.org. but that does not > contribute much to my reqirements. I want low level API's so that we can > reduce the parsing time taken by the sqlite parser. >

Re: [sqlite] Low Level API for SQLite3

2006-05-07 Thread John Stanton
:[EMAIL PROTECTED] Sent: Monday, May 08, 2006 10:25 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Low Level API for SQLite3 Anish Enos Mathew wrote: Any body know whether there are any low level C API's for sqlite3 ? Ummm - how about the native one ? -- Lindsay

RE: [sqlite] Low Level API for SQLite3

2006-05-07 Thread Anish Enos Mathew
To: sqlite-users@sqlite.org Subject: Re: [sqlite] Low Level API for SQLite3 Anish Enos Mathew wrote: > Any body know whether there are any low level C API's for sqlite3 ? > Ummm - how about the native one ? -- L

Re: [sqlite] Low Level API for SQLite3

2006-05-07 Thread Bill KING
Anish Enos Mathew wrote: > Any body know whether there are any low level C API's for sqlite3 ? > > > ** > > The information contained in, or attached to, this e-mail, contains > confidential information and is intended solely for the use of

[sqlite] Low Level API for SQLite3

2006-05-07 Thread Anish Enos Mathew
Any body know whether there are any low level C API's for sqlite3 ? ** The information contained in, or attached to, this e-mail, contains confidential information and is intended solely for the use of the individual or entity to whom