Re: [sqlite] SQLite version 3.7.5

2011-02-01 Thread Petite Abeille
On Feb 1, 2011, at 2:32 AM, Richard Hipp wrote: > performance is improved over the previous release by 1% or 2%. Hmmm... under 3.7.3, a little process of mine was handling around 52M records (~3GB) in about 113 minutes... now, with 3.7.5, the same process, running on the same machine, under

[sqlite] Sqlite and windows server 2008 DFS

2011-02-01 Thread Marco Turco
Hi, any experience using an sqlite db on Windows server 2008 with DFS enabled ? A customer with this configuration reported me that there is a lost of data. Marco ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite version 3.7.5

2011-02-01 Thread Clark Christensen
- Original Message From: Richard Hipp To: General Discussion of SQLite Database ; sqlite-annou...@sqlite.org Sent: Mon, January 31, 2011 5:32:15 PM Subject: [sqlite] SQLite version 3.7.5 >As of this release, the popular ADO.NET provider for

[sqlite] BUG REPORT: 3.7.5 fails to compile with SQLITE_OMIT_WAL

2011-02-01 Thread Noah Hart
The routine pager_write_changecounter in pager.c at line 2933 is eliminated by the #ifndef SQLITE_OMIT_WAL at line 2854 This causes a compile error in the pager_write_pagelist routine at line 4014 error LNK2001: unresolved external symbol _pager_write_changecounter@4 pager.obj sqlite3

Re: [sqlite] Optimising a bad design decision

2011-02-01 Thread Ian Hardingham
Many thanks Puneet and Igor - I will do those things. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Optimising a bad design decision

2011-02-01 Thread Puneet Kishor
On Tuesday, February 1, 2011 at 10:30 AM, Ian Hardingham wrote: > Hi Igor, thankyou. > > If I wish to make this modification now, what steps would I need to > take? And in your opinion what % of the optimisation of doing it with > integers would this provide? > ALTER TABLE MyTable RENAME TO

Re: [sqlite] Optimising a bad design decision

2011-02-01 Thread Igor Tandetnik
On 2/1/2011 11:30 AM, Ian Hardingham wrote: > If I wish to make this modification now, what steps would I need to > take? Export data from the table, drop table, recreate table with the new schema, import data back. Update all queries from LIKE to =. > And in your opinion what % of the

Re: [sqlite] Optimising a bad design decision

2011-02-01 Thread Ian Hardingham
Hi Igor, thankyou. If I wish to make this modification now, what steps would I need to take? And in your opinion what % of the optimisation of doing it with integers would this provide? Thanks, Ian On 01/02/2011 16:19, Igor Tandetnik wrote: > On 2/1/2011 10:10 AM, Ian Hardingham wrote: >> My

Re: [sqlite] Optimising a bad design decision

2011-02-01 Thread Igor Tandetnik
On 2/1/2011 10:10 AM, Ian Hardingham wrote: > My core users table has a user defined by a string which is their name. > This string is used to address many other tables relating to users. Not > only is the primary key a string (which I understand is bad enough), but > I also have to use LIKE

Re: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

2011-02-01 Thread Tito Ciuro
Hello Marian, On Feb 1, 2011, at 1:28 PM, Marian Cascaval wrote: > Since this topic has lead to different sub-topic I dare ask a question (I'm a > beginner both in C++ and, Oh boy, in SQLite too). > > Tito, do you really need the 5th argument in sqlite3_prepare_v2() i.e. > ""? > From what I

Re: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

2011-02-01 Thread Marian Cascaval
Since this topic has lead to different sub-topic I dare ask a question (I'm a beginner both in C++ and, Oh boy, in SQLite too). Tito, do you really need the 5th argument in sqlite3_prepare_v2() i.e. ""? >From what I understand from your code, there's only one SQL statement to be prepared, so

Re: [sqlite] Optimising a bad design decision

2011-02-01 Thread Drake Wilson
Quoth Ian Hardingham , on 2011-02-01 15:10:43 +: [paragraphs reordered] > As there are hundreds of queries around my server codebase I would > prefer not to have to change every single one to use a numeric id for a > user rather than a string - but maybe this is the only

[sqlite] Optimising a bad design decision

2011-02-01 Thread Ian Hardingham
Hey guys. First off, thanks to all who have helped me in the recent weeks. We're in crunch on my project and my rather complicated server, combined with my lack of DB experience, has given me plenty of problems to deal with. My core users table has a user defined by a string which is their

[sqlite] Doc errors: Too many "checked out." in Status Parameters for database connections

2011-02-01 Thread Ralf Junker
There are far too many "checked out." in the following docs, probably left-overs from copy-paste operations: ** ^(SQLITE_DBSTATUS_LOOKASIDE_HIT ** This parameter returns the number malloc attempts that were ** satisfied using lookaside memory. Only the high-water value is meaningful; ** the

Re: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

2011-02-01 Thread Tito Ciuro
Hi Drake, On Feb 1, 2011, at 9:33 AM, Drake Wilson wrote: > Quoth Tito Ciuro , on 2011-02-01 09:01:09 -0200: >> I don't think so. The fileSystemRepresentation method should we used >> when dealing with file-based paths. > > But not when dealing with SQLite paths, unless I'm

Re: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

2011-02-01 Thread Drake Wilson
Quoth Tito Ciuro , on 2011-02-01 09:01:09 -0200: > I don't think so. The fileSystemRepresentation method should we used > when dealing with file-based paths. But not when dealing with SQLite paths, unless I'm mistaken about what fileSystemRepresentation does. sqlite3_open_v2

Re: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

2011-02-01 Thread Tito Ciuro
Hi Afriza, On Feb 1, 2011, at 4:16 AM, Afriza N. Arief wrote: > On Tue, Feb 1, 2011 at 3:38 AM, Tito Ciuro wrote: > >> Hello, >> >> The following code snippet runs fine on Mac OS X, but fails on the iOS >> simulator: >> >> // Obtain a path for the database >> NSString

Re: [sqlite] integer or string in fts3 table

2011-02-01 Thread Gabe da Silveira
On Mon, Jan 31, 2011 at 9:27 PM, Samuel Adam wrote: > I can’t help you there other than to say, give your boss the facts and > point out that if QA approved that schema, QA failed its job. Would that it were it so easy. Unfortunately I work for a startup, and this code was

Re: [sqlite] WAL for single user database on NFS and Solaris

2011-02-01 Thread Richard Hipp
On Sat, Jan 29, 2011 at 10:06 PM, Ginn Chen wrote: > I think a single process accessing a single Sqlite database at a time over > NFS is supposed to be fine. > > But it is not working on Solaris. > On Solaris, man page of mmap() has > > EAGAINThe file to be mapped

Re: [sqlite] Cause of "disk I/O errors"

2011-02-01 Thread Nasron Cheong
I did report an issue much earlier on with regards to retrying io operations when some other process (like virus scanners) are touching the db file. Hopefully it will be of use to you: http://www.mail-archive.com/sqlite-users@sqlite.org/msg51895.html - Nasron Cheong

Re: [sqlite] WAL for single user database on NFS and Solaris

2011-02-01 Thread Shawn Wilsher
On Mon, Jan 31, 2011 at 5:44 AM, Dan Kennedy wrote: > Right. At most a single connection at a time. Unfortunately, that won't work for this issue since we use more than one connection in our process. Cheers, Shawn ___

[sqlite] WAL and big transaction

2011-02-01 Thread Akaiten
The documentation says that "for transactions in excess of a gigabyte, WAL mode may fail with an I/O or disk-full error". Can anybody explain for what exact situations an I/O error occurs? I have tested transaction in excess of 2Gb several times on Windows platform with the latest SQLite version