Re: [sqlite] Direct use of SQLite btree functions / performance

On Wed, 19 Apr 2006, Joe Wilson wrote: >--- [EMAIL PROTECTED] wrote: >> Joe Wilson <[EMAIL PROTECTED]> wrote: >> > >> > If you read the blob all in at once, true. >> > But doesn't sqlite3BtreeData() allows you to read a partial chunk of >> > data from the blob at an arbitrary offset? This could

Re: [sqlite] MMAP

At the risk of this turning into another argument between us... On Thu, 20 Apr 2006, John Stanton wrote: >Q How do programs get to be slow and bloated? >A One small inefficiency at a time. > >It is just as inefficient to send dynamically created content through a >series of buffers as it is to

[sqlite] upgrading versions of database files across version of SQLite

> We have been using SQLite ( v2.8.6 ) for a while now and as part of a new > release were thinking of moving ahead to a more current version. > > But that is where the issues began. I did search the archives, but found > noting of any real use on this. The same with the faq page and the

Re: [sqlite] upgrading versions of database files across version of SQLite

On Thu, 20 Apr 2006, Steve Bland wrote: > We have been using SQLite ( v2.8.6 ) for a while now and as part of a > new release were thinking of moving ahead to a more current version. > > But that is where the issues began. I did search the archives, but found > noting of any real use on this. The

Re: [sqlite] Direct use of SQLite btree functions / performance

> > > > sqlite3BtreeData() actually reads a prefix of the data. > > Because of the way large blobs are stored (as a linked list > > of disk pages) you have to start reading at the beginning > > and read everything up to the point of interest. > > Random access for blobs would be ideal, but even a

Re: [sqlite] Direct use of SQLite btree functions / performance

Jay Sprenkle wrote: > Just out of curiosity why is this data in the database? > I've seen very few applications where the blob is indexed or operated upon > by the database and it's always a pain to deal with it. We always just > left binary data in the file system and stored references to it in

[sqlite] Could not add Sqlite.dll to my project...Plz Help.

Hi Everyone, I am a new user to SQLite. I could not add sqlite.dll to my project. When i try to add the reference, it raises this error: “A reference to “c:\Downloads\SQLite\SQLite.Net1.0.0\sqlite.cll” could not be added. This is not a valid assembly or COM component. Only

[sqlite] Using sqlite3_open or sqlite3_open16?

Hi, I have an application that needs to open a database in the users's personal folder. I noticed that in some circunstances the sqlite3_open fail as the filename is in UTF16 format. I don't know that in advance so I could open the db with sqlite3_open16. The question is: Is it safe to always

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

On Thu, 20 Apr 2006, DBTools Software wrote: >Hi, > >I have an application that needs to open a database in the users's personal >folder. I noticed that in some circunstances the sqlite3_open fail as the >filename is in UTF16 format. I don't know that in advance so I could open >the db with

Re: [sqlite] Could not add Sqlite.dll to my project...Plz Help.

- Original Message - From: "Dhivya" <[EMAIL PROTECTED]> To: Sent: Thursday, April 20, 2006 6:44 AM Subject: [sqlite] Could not add Sqlite.dll to my project...Plz Help. Hi Everyone, I am a new user to SQLite. I could not add sqlite.dll to my project.

Re: [sqlite] Direct use of SQLite btree functions / performance

On 4/20/06, Dennis Jenkins <[EMAIL PROTECTED]> wrote: > Jay Sprenkle wrote: > > Just out of curiosity why is this data in the database? > > I've seen very few applications where the blob is indexed or operated upon > > by the database and it's always a pain to deal with it. We always just > > left

Re: [sqlite] Direct use of SQLite btree functions / performance

On 20-Apr-06, at 9:10 AM, Jay Sprenkle wrote: Just out of curiosity why is this data in the database? I've seen very few applications where the blob is indexed or operated upon by the database and it's always a pain to deal with it. We always just left binary data in the file system and

[sqlite] More on: Windows problem when updating after reboot

I've looked some more at this (unfortunately using 2.8.16 although the problem is also exhibited by 3.3.4) and the problem seems to be in sqlitepager_commit and its call to pager_get_all_dirty_pages which returns every page of the database as dirty and then proceeds to write every page to

Re: [sqlite] MMAP

Christian Smith wrote: At the risk of this turning into another argument between us... On Thu, 20 Apr 2006, John Stanton wrote: Q How do programs get to be slow and bloated? A One small inefficiency at a time. It is just as inefficient to send dynamically created content through a series

[sqlite] B#

This is an interesting development for embedded system developers who use Sqlite. http://www.embedded.com/showArticle.jhtml?articleID=183700818 http://www.embedded.com/showArticle.jhtml?articleID=185302940 Quote - The week before ESC Silicon Valley, the number of you who clicked on Part 1 in

Re: [sqlite] SQL statements in progress error message

Nicholas Bastin wrote: > When trying to commit a transaction, I'm getting the following error > message from sqlite3_exec(): > > "cannot commit transaction - SQL statements in progress" > > Is there any way to find out what statements are in progress? Also, > what could cause this? I can

Re: [sqlite] How to force to block sqlite file, while my conecction is open !

Hi, all ! > What kind of error is closing your transaction? When SQLite hits > an error, it usually leaves the transaction open. i think that above it's not completed true, think you have a table with a UNIQUE constraint, when you create a transaction and send a insert that violates this