Re: [sqlite] Virtual Memory Size used looks too large

On 20 February 2014 04:35, Clemens Ladisch wrote: > Woody Wu wrote: >> On 19 February 2014 23:09, Clemens Ladisch wrote: >>> Woody Wu wrote: sqlite is using mmap to map the database file? >> >> How do I confirm that this is true on Linux platform? > >

Re: [sqlite] Trying to use in-memory database

On Wed, Feb 19, 2014 at 5:25 PM, Jeff Archer < jsarc...@nanotronicsimaging.com> wrote: > Long time SQLite user but I don't think I have ever tried to do an > in-memory database before. > Just upgraded to 3.8.3.1 but I am not having any other failures with > existing code so I don't think that is

[sqlite] Trying to use in-memory database

Long time SQLite user but I don't think I have ever tried to do an in-memory database before. Just upgraded to 3.8.3.1 but I am not having any other failures with existing code so I don't think that is any part of the problem. I am trying to open the database with sqlite3_open16() using a filename

Re: [sqlite] Virtual Memory Size used looks too large

Woody Wu wrote: > On 19 February 2014 23:09, Clemens Ladisch wrote: >> Woody Wu wrote: >>> sqlite is using mmap to map the database file? > > How do I confirm that this is true on Linux platform? PRAGMA mmap_size >>> If this is the reason, how can I reduce the VSZ used? >>

Re: [sqlite] select/count/group by question

> Message: 10 > Date: Wed, 19 Feb 2014 09:11:27 -0500 > From: Igor Tandetnik > > select strftime(...) as year, sum(ISO=100) > FROM exifdata GROUP BY year ORDER BY year; > > -- > > Message: 11 > Date: Wed, 19 Feb 2014 09:16:56 -0500 > From: Richard Hipp > Maybe

Re: [sqlite] Virtual Memory Size used looks too large

On 19 February 2014 23:09, Clemens Ladisch wrote: > Woody Wu wrote: >> I found my sqlite application presents a huge VSZ usage, 100+M in an >> ARM system, which has only 128M physical memory. Does this because >> sqlite is using mmap to map the database file? > > This is

Re: [sqlite] Virtual Memory Size used looks too large

Woody Wu wrote: > I found my sqlite application presents a huge VSZ usage, 100+M in an > ARM system, which has only 128M physical memory. Does this because > sqlite is using mmap to map the database file? This is likely. > If this is the reason, how can I reduce the VSZ used? You could disable

[sqlite] Virtual Memory Size used looks too large

Hi, List I found my sqlite application presents a huge VSZ usage, 100+M in an ARM system, which has only 128M physical memory. Does this because sqlite is using mmap to map the database file? If this is the reason, how can I reduce the VSZ used? I checked my application with Valgrind, I think

Re: [sqlite] select/count/group by question

On Wed, Feb 19, 2014 at 9:04 AM, Patrick Proniewski wrote: > Hello, > > I'm currently designing a small tool with shell scripts, sqlite3 backend, > and gnuplot for graphical output. > My SQLite database has one table, each row being a picture name and a > subset of its EXIF

Re: [sqlite] select/count/group by question

On 2/19/2014 9:04 AM, Patrick Proniewski wrote: For ISO = 100, I issue this request: SELECT strftime("%Y", datetime(CreateDate,"unixepoch")) as year, COUNT(ISO) FROM exifdata WHERE ISO = 100 AND year not null GROUP BY ISO, year ORDER BY year; That is correct, but not enough: the database

[sqlite] select/count/group by question

Hello, I'm currently designing a small tool with shell scripts, sqlite3 backend, and gnuplot for graphical output. My SQLite database has one table, each row being a picture name and a subset of its EXIF tags (date, ISO, metering mode...). In order to process data into gnuplot, I use SELECT to

Re: [sqlite] SQLite for Windows Phone bug

Have you activated the error and warning log to see if it gives you any further diagnostics? http://www.sqlite.org/errlog.html On Wed, Feb 19, 2014 at 12:06 AM, Martin Zikmund wrote: > Hello, SQLite team, > > > I would like to report a bug in the Windows Phone version

Re: [sqlite] SQLite for Windows Phone bug

On 19 Feb 2014, at 5:06am, Martin Zikmund wrote: > SQL logic error or missing database The two usual causes of this under WinMob are both related to permissions and privileges. The folder the database file is stored in may be protected against the app opening the

[sqlite] SQLite Windows Phone bug

Sorry for another mail, but I forgot to mention, that the bug seems to arise only in transaction. When the items are inserted individually, it seems to be working correctly (although I can’t confirm it 100 %). Hello, SQLite team, I would like to report a bug in the Windows Phone version

[sqlite] SQLite for Windows Phone bug

Hello, SQLite team, I would like to report a bug in the Windows Phone version of SQLite, that is already present for three releases in the row. The problem arises quite randomly, when SQLite refuses to insert or update some items into database and throws the following error: SQL logic error

[sqlite] Re Problem related to ticket 4c86b126f2 ?

Here is a copy and paste of the shema involved : db1 eval {CREATE TABLE BulletinsTemp0 (\ IDPayeMens VARCHAR(19), \ CodSoc VARCHAR(3), \ CodEtabliss VARCHAR(3), \

[sqlite] How to disable the use of malloc()?

Hi, I want to omits the Sqlite's internal invocation of malloc(3). What I tried were following, 1. Provide sqlite compile time options "-DSQLITE_ZERO_MALLOC -DSQLITE_ENABLE_MEMSYS5" 2. In the startup code of my application, call: sqlite3_config(SQLITE_CONFIG_HEAP, my_static_array, ...) Do you