Nuno Lucas wrote:
On 4/18/06, Christian Smith <[EMAIL PROTECTED]> wrote:
The OS has to track each MMAP segment, which is usually a linear linked
list sorted by virtual address. As most processes don't have that many
segments mapped (10's of segments would be considered a lot) the O(n)
linear
Chris, Thanks for the very pertinent comments on segment linking.
I am not sending an Sqlite database. It is the output from my program,
principally assembled HTML/PDF/PostScript and similar.
I want to avoid buffer shadowing on the content my program creates. If
I use a malloc'd buffer it
The file opening and connect overhead would make your strange idea
slower almost definitely if you use many tables.
Cesar David Rodas Maldonado wrote:
any one can answer me?
On 4/15/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
Hello
I have a software that uses four tables.
[EMAIL PROTECTED] wrote:
The ROWID is generated after the BEFORE triggers fire and
before the row is inserted.
OK, I think I'm getting it. The INSERT statement generates the ROWID,
fires triggers, then inserts the row. When the transaction is
committed, all that is committed; when the
Michael Ekstrand <[EMAIL PROTECTED]> wrote:
> Will Leshner wrote:
> > On 4/17/06, Michael Ekstrand <[EMAIL PROTECTED]> wrote:
> >
> >> So, if someone could enlighten me as to the defined behavior of
> >> sqlite3_last_insert_rowid with regards to transactions, I would be most
> >> grateful.
> >
>
Will Leshner wrote:
On 4/17/06, Michael Ekstrand <[EMAIL PROTECTED]> wrote:
So, if someone could enlighten me as to the defined behavior of
sqlite3_last_insert_rowid with regards to transactions, I would be most
grateful.
The last insert id is a property of a connection. So there is no way
Hi Christian,
On 18/04/2006, at 8:22, Christian Smith wrote:
SQLite will make possible whatever is safe. Just be prepared to handle
SQLITE_BUSY and SQLite will take care of the rest.
Great. This is what I do now. No worries here then...
If the indexing process uses a large SQLite cache
On Sat, 15 Apr 2006, Tito Ciuro wrote:
>Hello,
>
>I was wondering whether it is safe to read or write a table while
>being indexed. Here's a scenario: for batch imports, it's sometimes
>better to DROP the indexes, do the INSERTs and then recreate the
>relevant indexes. Indexing may take a little
On Sun, 16 Apr 2006, John Stanton wrote:
>I wonder if members can help me with some advice. I have a program
>which is a multi-threaded application server with Sqlite embedded which
>runs on Unix and Windows. For an i/o buffer per thread I have the idea
>of using a mmap'd file so that it can be
Welcome to quoting hell. :-)
But I had a tcl tablecopy, and my databases all have a data definition so
doing it the right way was real easy. But I did want to point out that the
recommended .DUMP method is flawed.
Regards, Paul Nash
webscool.org
- Original Message -
From: "Jay
Am 15.04.2006 um 00:50 schrieb Thomas Chust:
On Fri, 14 Apr 2006, Will Leshner wrote:
On 4/14/06, Thomas Chust <[EMAIL PROTECTED]> wrote:
I just downloaded the 3.3.5 distribution tarball and confirmed
that the
problem occurs with a binary built from that codebase as well.
I assume you
11 matches
Mail list logo