[sqlite] Memory usage (3.1.0 alpha)

I am benchmarking sqlite3 as a potential database for Windows and embedded applications. I am running the following code in a Rapid development environment that calls the equivalent sqlite3 functions in a Window's DLL that I built from the release . I am seeing that memory usage goes up and

Re: [sqlite] Memory usage (3.1.0 alpha)

sqlite3_finalize. Is that correct? Perhaps the normal behaviour of sqlite3 is to use system memory until there is non left? I cannot find a #define that specifies how many database pages are cached in memory. Clive Ulrik Petersen <[EMAIL PROTECTED]> on 30-01-2005 00:44:01 Please r

Re: [sqlite] slow "INSERT"

You should use a transaction otherwise sqlite syncs the file for every INSERT. Clive "Alessandro Renzi (RM/TEI)" <[EMAIL PROTECTED]> on 31-01-2005 11:49:24 Please respond to sqlite-users@sqlite.org To: "'sqlite-users@sqlite.org'" <sqlite-users@sqlite.or

[sqlite] Compacting a database

Is there a way to compact a database after removing data? Clive

Re: [sqlite] Compacting a database

Thanks. I am not sure this is very useful, because it copies the database, which requires that there be enough file space for a copy. It would be nice if there was something that worked by truncating the file. Clive Dick Davies <[EMAIL PROTECTED]> on 01-02-2005 13:40:13 Please r

Re: [sqlite] Not getting the speed I think is possoble. Basic select statment slow?

What speed were you expecting? Are you comparing it to another database? If so what are the results for that database? Clive "Chris Schirlinger" <[EMAIL PROTECTED]> on 02-02-2005 06:00:45 Please respond to [EMAIL PROTECTED] To: sqlite-users@sqlite.org cc:(bc

Re: [sqlite] Not getting the speed I think is possoble. Basic select statment slow?

Did you try increasing the page cache size. Your data set is very big. pragma page_cache = 2; This should at least improve the speed for queries. Clive "Chris Schirlinger" <[EMAIL PROTECTED]> on 02-02-2005 09:07:49 Please respond to [EMAIL PROTECTED] To: sqlite-

[sqlite] Sorted index

, and then when I add a new entry to the table it would automatically be inserted in the index at the correct position. Is this possibe? If not, can anyone suggest any other solution, baring in mind that RAM memory needs to be kep to a minimum? Thanks Clive

Re: [sqlite] Stack usage

This is very worrying since it means that the statement cannot be compiled on a low memory device. I am new to Sqlite, but I would guess that a precompiled query could be used, where memory is low and I also suppose that variable values could be bound to that precompiled query. Clive

[sqlite] Index size in file

. Clive - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Index size in file

if it is possible to create an index in memory? Clive John Stanton <[EMAIL PROTECTED]> on 03/10/2007 17:36:58 Please respond to sqlite-users@sqlite.org To: sqlite-users@sqlite.org cc:(bcc: clive/Emultek) Subject: Re: [sqlite] Index size in file An index which does not hold keys is not an

Re: [sqlite] Index size in file

>From what I read SQL Server has 2 basic types of index: 1. Clustered, that holds the single instance of the data itself (actaully the whole row) 2. Non-clustered that hold a pointer to the single instance of the data, but not the data itself. Clive John Stanton <[EMAIL PROTECTED]&

RE: [sqlite] Index size in file

Actually yes, I am programming for a cellphone and you are right, that is the only reason I am thinking about it! Clive "Griggs, Donald" <[EMAIL PROTECTED]> on 04/10/2007 21:23:17 Please respond to sqlite-users@sqlite.org To: sqlite-users@sqlite.org cc:(bc

Re: [sqlite] Index size in file

to referencing the original data. Clive John Stanton <[EMAIL PROTECTED]> on 05/10/2007 00:54:21 Please respond to sqlite-users@sqlite.org To: sqlite-users@sqlite.org cc:(bcc: clive/Emultek) Subject: Re: [sqlite] Index size in file Trevor Talbot wrote: > On 10/4/07, Joh

[sqlite] step back

sqlite3_step() is great for scrolling forward through a result set. Is there a way to scroll backwards? If not, did anyone try implementing it? (I guess that the indexes would need backward pointers in order to do it.) Clive

[sqlite] Temporary index

In the documentation below under the Pragmas section there seems to be a hint that I can create a temporary index. However the CREATE INDEX syntax does not allow the word TEMPORARY to be used. Anyone know what is going on? Clive PRAGMA temp_store; PRAGMA temp_store = DEFAULT; (0) PRAGMA

Re: [sqlite] just a test

Igor's messages sometimes get marked as spam by gmail. -- Clive Hayward On 2012-12-03, at 7:57 AM, e-mail mgbg25171 <mgbg25...@blueyonder.co.uk> wrote: > I've posted a couple of mails lately...I'm not getting them via the list or > any responses. > Admin says Igor responded

Re: [sqlite] How to build a new sqlite3.dylib?

it # Display the names and version numbers of the shared libraries that the object file uses. otool -L ./shell ./shell: libsqlite3_mybuild.dylib (compatibility version 0.0.0, current version 0.0.0) /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 159.1.0) Best