Re: [sqlite] Checkpoint time

There is another reader but sharing the same connection. So checkpoint process cannot be blocked by another reader. On Thu, Dec 1, 2011 at 8:54 PM, Yves Goergen wrote: > On 01.12.2011 18:58 CE(S)T, Sreekumar TP wrote: > > During the measurement of manual checkpoint

[sqlite] SQLite ordering data from multiple columns

Hi I have a database with following structure NO | Emp Name | Emp Desc 1 EMP1 this is EMP1 2 EMP2this is EMP2 I want to search this database I will search Emp Name & Emp Desc for example If Search EMP I will get results as EMP1 , this is EMP1, EMP2, this

[sqlite] Slow View when it is used in a where clause

Hello, I am new in this mailing list. I am developing a Java tool and I use SQLite as file format. At this moments, I did not have any problem, and SQLite works quite fine. I want to create some views to generate statistical and aggregate data in order to show more information to the user.

[sqlite] Help with an SQL statement

Hi all: Assuming a normal table: CREATE TABLE names (Id INTEGER PRIMARY KEY, Nm INTEGER); And an FTS4 table: CREATE VIRTUAL TABLE fts USING fts4 (name, tokenize=simple); I want populate the FTS4 table from the content of the names table using the second form of the INSERT statement: INSERT

Re: [sqlite] Checkpoint time

On 01.12.2011 18:58 CE(S)T, Sreekumar TP wrote: > During the measurement of manual checkpoint times, I see the following > behaviour - > > # of WAL frames checkpointed is over 1000 > size of DB has not changed after checkpoint.(measured using fstat) > Time for the checkpoint if around 500 ms. >

Re: [sqlite] Managed only / Mono and Linux support

On 29.11.2011 04:49 CE(S)T, Joe Mistachkin wrote: >> So what should I do about Mono/Linux support for SQLite in C#? >> > > If you have access to a Windows machine with MSBuild and/or Visual Studio, > compiling the managed-only binary is fairly simple. Okay, that works fine. On Linux. I still

[sqlite] Checkpoint time

Hello, During the measurement of manual checkpoint times, I see the following behaviour - # of WAL frames checkpointed is over 1000 size of DB has not changed after checkpoint.(measured using fstat) Time for the checkpoint if around 500 ms. Why is it that eventhough 1000+ frames are

Re: [sqlite] sqlite 3.7.8 and sqlite 3.7.9 crash with Apple Xcode 4.2.1 on armv6 ios device

Gilles, I haven't filed a bug on this, but from discussion with others it appears that Apple at least know about this compiler bug. I'm not at all sure that they intend to put the resources into fixing it any time soon: arm6 is an outdated architecture for them, as they haven't shipped devices

[sqlite] Very slow query

Hi, I have a problem with one of my queries which take 2 orders of magnitude more on Sqlite3 (3.7.9) compared with the identical query on PostgreSQL (8.4). Times are 2270 ms on Sqlite3 and around 17ms on PG. The difference seems to that the Sqlite is not optimising a subquery by using an

Re: [sqlite] iPhone iOS 3.1.3 Sqlite3 Crashes Unless Compiled Without Optimizations

The crash occur with sqlite 3.7.8 on line below:   u.bp.pC->nullRow = (u8)u.bp.res; u.bp.pC did not reference a valid address. here is the stack (gdb) bt #0  0x00055000 in sqlite3VdbeExec (p=0x18e9d8) at /Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:68038 #1  0x96d2 in sqlite3_step