"Ron, Shac" <[EMAIL PROTECTED]> wrote:
>
> Does this mean that issues pertaining to threads, particularly in
> passing a sqlite3* between threads, are now resolved?
This issue is a bug in some versions of Linux (2.4 kernels with
particular combinations of pthreads and glibc.) The problem is
tha
Hello all,
I was researching the meaning of the configure parameter
--enable-cross-thread-connections ("Allow connection sharing across
threads"). I've not found it documented anywhere, but in the 3.3.1
changelog I find "Database connections can now be used by multiple
threads, not just the threa
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
that one connection
I'm trying to figure out how sqlite3_last_insert_rowid() interacts with
transactions.
I've read the thread at
http://www.mail-archive.com/sqlite-users@sqlite.org/msg13393.html
However, the concern raised in the last message of that thread is
exactly my concern, and was never addressed in the cont
Thanks Richard Hipp and it will be more easy to use all in one file...
thanks for your help
On 4/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> "Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote:
> > any one can answer me?
> >
> > On 4/15/06, Cesar David Rodas Maldonado <[EMAIL PRO
> Some DBMS's (PostgreSQL comes to mind) do allow you to create an index
> which also forces the data to be ordered. This can speed up some
> patterns of read access, but makes inserts quite expensive and should be
> used only with extreme caution.
MS Sqlserver calls them 'clustered indexes'.
The
Some DBMS's (PostgreSQL comes to mind) do allow you to create an index
which also forces the data to be ordered. This can speed up some
patterns of read access, but makes inserts quite expensive and should be
used only with extreme caution.
chetana bhargav wrote:
Thanks for the info.
Thanks for the info.
Cheers,
Chetana.
Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 4/17/06, chetana bhargav wrote:
> Am I correct in saying that once we create an index on a table what ever the
> new records added would be done according to the index mentioned.
>
> If so, if we create an
On 4/17/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
> Am I correct in saying that once we create an index on a table what ever the
> new records added would be done according to the index mentioned.
>
> If so, if we create an index on a table which has already some records then
> will those
Am I correct in saying that once we create an index on a table what ever the
new records added would be done according to the index mentioned.
If so, if we create an index on a table which has already some records then
will those records be re-arranged.
Jay Sprenkle <[EMAIL PROTECTED]> wro
chetana bhargav
wrote:
I just want to know, if we create an index on any table, how the
index is stored, is it stored in a seperate file or as part of the
current table only in the same file.
With SQLite, the whole database is stored in a single file - all its
tables, indices, triggers, view
On 4/17/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
> I just want to know, if we create an index on any table, how the index is
> stored, is it stored in a seperate file or as part of the current table only
> in the same file.
There's only one file no matter how many tables or indexes you c
Hi,
I just want to know, if we create an index on any table, how the index is
stored, is it stored in a seperate file or as part of the current table only in
the same file.
Cheers,
Chetana
-
New Yahoo! Messenger with Voice. Call regu
On 4/14/06, Paul Nash <[EMAIL PROTECTED]> wrote:
> I have taken the plunge and am converting from ver 2.8.16 to ver 3.
>
> I used the .DUMP method but found a problem. My char/text fields containg
> numbers were output as pure numbers without the quotes, so that on input to
> ver 3 they were stor
On 4/16/06, John Stanton <[EMAIL PROTECTED]> wrote:
> 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 ide
Am 17.4.06 um 10:58 schrieb 杰 张:
Hi,all
I just want to implement to download a sqlite table in a
sqlite db from IE browser , but I must first convert sqlite format
into text format for reading data information of the table. I want
to finish the conversion automatically through so
Hi,all
I just want to implement to download a sqlite table in a sqlite db from
IE browser , but I must first convert sqlite format into text format for
reading data information of the table. I want to finish the conversion
automatically through some shell commands. Can I do it?
Thank
Thomas Chust,您好!
the mail num is so many,
how can cancel the maillist.
=== 2006-04-16 16:03:00 您在来信中写道:===
>On Sun, 16 Apr 2006, [EMAIL PROTECTED] wrote:
>
>> Thomas Chust <[EMAIL PROTECTED]> wrote:
>>> Hello,
>>>
>>> I have a table of strings and integer primary keys from which
18 matches
Mail list logo