Re: [sqlite] benchmarking UTF8 vs UTF16 encoded databases

On Nov 22, 2007 1:04 PM, Daniel Önnerby <[EMAIL PROTECTED]> wrote: > In the future I am using UTF8 encoded databases since the conversion of > strings is a small thing for the system. The advantages of using UTF8 > are many: > 1. Faster in most cases > 2. Smaller databases (30% smaller in

Re: [sqlite] Sqlite version for libc 2.1.3

On 11/22/07, Tara_Nair <[EMAIL PROTECTED]> wrote: > I just recently started to use Sqlite3 version 3.5.2 on an ARM-LINUX > based embedded platform. > Sqlite3-v3.5.2. has a dependency on libc, ld and libpthread versions 2.2.3. Er.. it should depend on whatever versions you link it against when

[sqlite] Sqlite version for libc 2.1.3

Hello all, I just recently started to use Sqlite3 version 3.5.2 on an ARM-LINUX based embedded platform. Sqlite3-v3.5.2. has a dependency on libc, ld and libpthread versions 2.2.3. My sorrow is that the rest of my application and the libraries on my ramdisk are of version 2.1.3. It doesn't seem

[sqlite] wrong version number when compiled

Hi all: I've just downloaded, compiled and installed SQLite3 3.5.2 on my mac. Everything is working fine but the version number. I know OS X 10.4 comes with SQLite built-in on /usr/bin. I installed 3.5.2 on /usr/local and updated my PATH so that is all right. Look at what I get: xabita:/

[sqlite] Reported Error with SQLITE_MEMORY_SIZE

3.5.2 from the ZIP file, Compiled under Visual Studio 2005. Static Library SQLITE_OMIT_AUTHORIZATION SQLITE_OMIT_AUTOVACUUM SQLITE_OMIT_BLOB_LITERAL SQLITE_OMIT_DATETIME_FUNCS _CRT_SECURE_NO_DEPRECATE SQLITE_MEMORY_SIZE=100 SQLITE_CORE A couple weeks ago I reported a crash when I used the

[sqlite] benchmarking UTF8 vs UTF16 encoded databases

When I started using SQLite I found it natural to use the sqlite3_open16 and use UTF16 encoding on strings since my applications always use wchar_t when handeling strings. I never questioned this until now when I decided to do some benchmark, and I found it interesting enough to share with

Re: [sqlite] SQLite Announcements

At 2:47 PM + 11/22/07, Alberto Simões wrote: Is it just me, or SQLite announcements for new releases are not being sent to this list? At least I didn't see 3.5.0, 3.5.1 and 3.5.2 announcements. I am aware of them just because complain about them :) I saw the 3.5.0 announcement on this

RE: [sqlite] SQL error: database disk image is malformed - SQLITE3.5.1

-Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: quinta-feira, 22 de novembro de 2007 12:58 To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQL error: database disk image is malformed - SQLITE3.5.1 > > > There is a good description of the things that can cause

Re: [sqlite] integrity_check needs too much RAM on WinCE

Dennis Cote schrieb: > Thomas Damme wrote: >> We set "page_size" and "cache_size" both at 8KB because it had the best >> performance on the device. >> > Do you have 64 MB of ram to dedicate to sqlite for its cache? That's > what you are telling it by setting the cache to 8K pages of 8K each.

Re: [sqlite] integrity_check needs too much RAM on WinCE

Thomas Damme wrote: We set "page_size" and "cache_size" both at 8KB because it had the best performance on the device. Do you have 64 MB of ram to dedicate to sqlite for its cache? That's what you are telling it by setting the cache to 8K pages of 8K each. Dennis Cote

Re: [sqlite] integrity_check needs too much RAM on WinCE

Oh, maybe I should also tell you this: We set "page_size" and "cache_size" both at 8KB because it had the best performance on the device. Thomas Damme schrieb: > Hello Folks, > > we are running a SQLite-Database(version 3.3.5) on a > WinCE-device(version 4.2). The database is about 90 MB and

[sqlite] integrity_check needs too much RAM on WinCE

Hello Folks, we are running a SQLite-Database(version 3.3.5) on a WinCE-device(version 4.2). The database is about 90 MB and resides on a USB-Stick. The database itself contains of about 500 records with BLOBs from 1KB to 100 KB. When we are running an "PRAGMA integrity_check" the device stops

Re: [sqlite] SQL error: database disk image is malformed - SQLITE 3.5.1

Salles, Joaquim Campos wrote: Now running the command "PRAGMA integrity_check": sqlite> PRAGMA integrity_check; *** in database main *** Main freelist: 138691677 of 4 pages missing from overflow list starting at 2972 On tree page 322 cell 0: 3 of 4 pages missing from overflow list starting at

[sqlite] SQLite Announcements

Hi Is it just me, or SQLite announcements for new releases are not being sent to this list? At least I didn't see 3.5.0, 3.5.1 and 3.5.2 announcements. I am aware of them just because complain about them :) Cheers ambs -- Alberto Simões

[sqlite] SQLITE_THREAD_OVERRIDE_LOCK

Hi, I am not clear on when this flag must be enabled. SQLITE_THREAD_OVERRIDE_LOCK What are the implications of enabling this. Thanks, Kiran *** This e-mail and attachments

[sqlite] SQL error: database disk image is malformed - SQLITE 3.5.1

I'm using SQLITE 3.5.1 - in Linux, Had Red 7.1, with a single thread application - and 2 different programs accessing the same database. I am getting the following message: SQL error: database disk image is malformed. I copy the database to windows and run with sqlite and also get the same

Re: [sqlite] error

Thanks On Nov 22, 2007 6:35 PM, Dennis Povshedny <[EMAIL PROTECTED]> wrote: > Hi! > > Place the limit clause at the end. > > select * from databaseentry where Sub="BarsandPubs" order by Button_Name > limit 5; > > Regards, > Dennis > > > Xeepe Phone Solution Team > http://en.xeepe.com >

Re: [sqlite] Resetting a Primary Key

Hi Vincent, On 11/21/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: > I have a primary key that auto increments and has apparently > overlapped back on to itself. > > INSERT into mytable(id,name) values(NULL,'test'); > > .. is giving me "primary key must be unique" errors. > > How can I reset