I was investigating if file mapping could be used under win32, but
have run into a roadblock. The win32 documentation for MapViewOfFile
(which is the part that maps the drive data into memory) wants the
file offset to be a multiple of the allocation granularity of the
system. On my machine (XP Pro)
- Original Message -
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To:
Sent: Friday, June 17, 2005 9:42 PM
Subject: Re: [sqlite] license to hack: pager in shmem
> On Fri, 2005-06-17 at 21:21 -0400, Paul G wrote:
> > i might put in some work on this, although it's a bit more work than i'd
On Fri, 2005-06-17 at 21:21 -0400, Paul G wrote:
> i might put in some work on this, although it's a bit more work than i'd
> hoped (shm would have been faster afair). will this patch, assuming it looks
> decent and works (for a reasonable threshold of 'works'), be accepted into
> trunk? it's a bit
richard,
comments inline:
- Original Message -
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To:
Sent: Friday, June 17, 2005 8:54 PM
Subject: Re: [sqlite] license to hack: pager in shmem
> On Fri, 2005-06-17 at 20:16 -0400, Paul G wrote:
> > i'd like to hack sqlite3 to use shared memory
On Fri, 2005-06-17 at 20:16 -0400, Paul G wrote:
> i'd like to hack sqlite3 to use shared memory for the page cache.
>
A more useful hack, perhaps, would be to change the pager to use
memmap() (when available) instead of read() and write(). This
allows multiple instances of SQLite to use the sa
folks,
for better or for worse, i'm going to use sqlite3 as a local cache for some
of my preciousss objects (permanent persistence target is mysql). this is in
a php app, so the obvious problem is having multiple sqlite page caches (one
per apache process).
therefore, unless well informed people
On Fri, 2005-06-17 at 16:54 -0700, Randall Fox wrote:
> I would suspect it is something to do with your setup.. In fact I have
> only once seen an INTERNAL COMPILER ERROR when using VC++, and it was my
> fault.
>
I don't use VC++. But I have gotten a few "internal errors" on the
compiler
I do
When I then try to build the project, I get internal compiler errors.
Here are the first few lines of 35 errors it has:
I have built v3.08 and v2.x using VC++ 6 and 7.x
You do get a lot of casting warnings (which you can turn off/ignore),
but I never got a compiler error.
I would suspect
Hi,
I am building sqlite 3.2.2 on windows with MS VC++ 6.0. I am doing this
because I believe I need the .lib file to use the .dll with my code.
Based on this message:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg04528.html
I created an emply DLL project and added the .c
I've been inserting data into a table with a non-integer primary
key. The data does not come in in an ordered fashion. My thought is
that perhaps performance suffers because it needs to rewrite huge
chunks of the data file in order to slot the new data into its
correct position within the file b
SQLite write (insert) performance doesn't seem very good to me so I'm
trying to find ways to improve it in my application. I had this idea
so I figured I'd run it past you folks who likely better know how the
db works under the hood.
did you wrap your inserts in a transaction?
I don't think
On Fri, 2005-06-17 at 14:02 -0500, Sean Heber wrote:
> I've been inserting data into a table with a non-integer primary
> key. The data does not come in in an ordered fashion. My thought is
> that perhaps performance suffers because it needs to rewrite huge
> chunks of the data file in orde
are you using a transaction? if not, go read the wiki.
On 6/17/05, Sean Heber <[EMAIL PROTECTED]> wrote:
> SQLite write (insert) performance doesn't seem very good to me so I'm
> trying to find ways to improve it in my application. I had this idea
> so I figured I'd run it past you folks who lik
On 6/17/05, Sean Heber <[EMAIL PROTECTED]> wrote:
> SQLite write (insert) performance doesn't seem very good to me so I'm
> trying to find ways to improve it in my application. I had this idea
> so I figured I'd run it past you folks who likely better know how the
> db works under the hood.
did y
SQLite write (insert) performance doesn't seem very good to me so I'm
trying to find ways to improve it in my application. I had this idea
so I figured I'd run it past you folks who likely better know how the
db works under the hood.
My thought is that perhaps the write performance suffers
True, so it would be great if there were a way to Lock the File aside
from using Transactions to do so. Perhaps some
windows API, or any other way?
Will Leshner <[EMAIL PROTECTED]> wrote on 06/17/2005 02:21:58 PM:
>
> On Jun 17, 2005, at 11:18 AM, [EMAIL PROTECTED] wrote:
>
> > However, I need
On Jun 17, 2005, at 11:18 AM, [EMAIL PROTECTED] wrote:
However, I need transactions for other purposes, as my
process is running it will need to BEGIN and COMMIT/ROLLBACK
transactions all the while holding the lock on the file.
Ah. You were hoping the transactions would be nested? That is
Ok, you're right, BEGIN EXCLUSIVE does lock the file
and keep it locked until COMMIT or ROLLBACK.
However, I need transactions for other purposes, as my
process is running it will need to BEGIN and COMMIT/ROLLBACK
transactions all the while holding the lock on the file.
Will Leshner <[EMAIL PRO
On Jun 17, 2005, at 10:52 AM, [EMAIL PROTECTED] wrote:
Yes, a BEGIN EXCLUSIVE does lock it, but then as soon
as I do some other SQL, it automatically UN LOCKS the
db unfortunately. I need to keep it locked until
I unlock it.
I'm not sure I believe you :) I would assume the database would be
Yes, a BEGIN EXCLUSIVE does lock it, but then as soon
as I do some other SQL, it automatically UN LOCKS the
db unfortunately. I need to keep it locked until
I unlock it.
Will Leshner <[EMAIL PROTECTED]> wrote on 06/17/2005 01:47:08 PM:
>
> On Jun 17, 2005, at 9:57 AM, de f wrote:
>
> > The
> >
On Jun 17, 2005, at 9:57 AM, de f wrote:
The
automatic
locking of Transactions in sqlite does not give me direct
control and is of no
use to me (those locks go away automatically, leaving me no
control over them.)
Are you sure? Have you investigated BEGIN EXCLUSIVE?
From everything I've read, I would have thought this
was the case. But in practice I have been seeing
transient SQLITE_CORRUPT errors. I tried "pragma
integrity_check" and it said ok.
I'm running my app on an embedded linux machine.
The db is in ramdisk and I'm using TEMP_STORE=3, so
eve
I need to Lock the entire DB from one process (locking other processes
out),
and Mainitain that lock until I specifically UNlock the DB. The automatic
locking of Transactions in sqlite does not give me direct control and is of
no
use to me (those locks go away automatically, leaving me no control
Why not use a mutex around your database code in your program?
-Original Message-
From: de f [mailto:[EMAIL PROTECTED]
Sent: Friday, June 17, 2005 9:58 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] How to Lock other threads out of DB until specifically
UNlocking the DB?
I need to Loc
I need to Lock the entire DB from one process (locking other
processes out),
and Mainitain that lock until I specifically UNlock the DB. The
automatic
locking of Transactions in sqlite does not give me direct
control and is of no
use to me (those locks go away automatically, leaving me no
contr
Hi Marc-André,
That's a much better way of doing this. Thanks!
Martin
P.S. Tes salutations sont rendues!
-Original Message-
From: Marc-Andre Gosselin [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 16, 2005 19:47
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Query on multiple tables
> I have updated my SQLite 3.x C++ wrapper (at
> http://dev.int64.org/sqlite.html).
What do you think of the idea of handling SQLITE_SCHEMA internally
instead of throwing an exception?
__
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check em
27 matches
Mail list logo