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 th
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
http://sqlite.org:8080/cgi-b
- 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 by Robert
>Simpson, System.Data.SQLite,
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
Movi
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
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 M
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 optimisat
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
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 rathe
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.
> "&oneSQL"?
> From wh
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.
"&oneSQL"?
>From what I understand from your code, there's only one SQL statement to be
prepared
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 real way of
> optimi
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 nam
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 curr
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 mistaken about what
>
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 always takes UTF-8 an
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 *docs =
>> [NSSearch
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 developed by a partne
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 is already locked u
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
_
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-users mailing list
sqlite-u
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 an
22 matches
Mail list logo