Sebastian Tennant <[EMAIL PROTECTED]>
wrote:
> I have three tables; users, propositions, and subscriptions:
>
> users
> -
> user_id user_name user_password user_email
>
> propostions
> ---
> prop_id proposition user_id
>
> subscriptions
>
"Andrew Finkenstadt" <[EMAIL PROTECTED]> wrote:
> I see a reference to SQLITE_BUSY_RESERVED_LOCK in version 3.3.15 (the first
> one with the amalgamation), but there does not appear to be support for it
> in the remainder of the source file.
>
> Is that correct?
So it appears
--
D. Richard
I see a reference to SQLITE_BUSY_RESERVED_LOCK in version 3.3.15 (the first
one with the amalgamation), but there does not appear to be support for it
in the remainder of the source file.
Is that correct?
Hi John! Thanks for the reply!
I think that makes a good point that the vm page fault is probably
faster than the overhead of copying the data to a local buffer. So, page
fault or not, I think that's the way I'm going to do it.
Again, thanks very much for your input!
On 6/12/07, John Stanton
It seems this was discussed just a few days ago. A recent upgrade to
SQLite allows inserts, updates and deletes on tables that are also open
for selection. The changes may or may not appear as I call
sqlite3_step(), but I can live with that.
RobR
On 6/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
It really looks like this UTF-8 codepage is not avaiable. Is there
any WinCE developer that uses SQLite newer than version 3.3.9 on this
list? -> Did you have similiar problems since the unicode conversion
functions were changed?
I
On 6/12/07, Omar Eljumaily <[EMAIL PROTECTED]> wrote:
When you create a function with sqlite3_create_function, the callback
function is something like:
myFunc(sqlite3_context *context, int argc, sqlite3_value **argv)
{
}
Is it possible to get the name of the function that the callback was
--- Omar Eljumaily <[EMAIL PROTECTED]> wrote:
> Is it possible to get the name of the function that the callback was
> called because of?
If you specified a userData argument in sqlite3_create_function()
you can retrieve it in the functon itself with
void
When you create a function with sqlite3_create_function, the callback
function is something like:
myFunc(sqlite3_context *context, int argc, sqlite3_value **argv)
{
}
Is it possible to get the name of the function that the callback was
called because of? I want to write just one callback
Mitchell Vincent wrote:
Working with some data conversion here (that will eventually go into
an SQLite database). I'm hoping you IO wizards can offer some help on
a question that I've been trying to get answered.
I'm using Solaris 10 for this.
If I mmap a large file and use madvise with
Greetings!
In the ADO world, I can have a recordset object that holds data from a
table. I can call AddNew() to add a record to the table, Update() to
change data in the current record, or Delete() to delete the current
record. But in the SQLite world, insertions, updates and deletions can
only
Working with some data conversion here (that will eventually go into
an SQLite database). I'm hoping you IO wizards can offer some help on
a question that I've been trying to get answered.
I'm using Solaris 10 for this.
If I mmap a large file and use madvise with MADV_SEQUENTIAL and
Quoth "Igor Tandetnik" <[EMAIL PROTECTED]>:
> Sebastian Tennant <[EMAIL PROTECTED]>
> wrote:
>> I have three tables; users, propositions, and subscriptions:
>>
>> users
>> -
>> user_id user_name user_password user_email
>>
>> propostions
>> ---
>> prop_id proposition
> If the performance problem is with the seconday index, is there a way to
> "pause" indexing before
> a large bulk insert and then "resume" it later without rebuilding the entire
> index (to avoid
> doing: drop index + inserts + create index)?
No
> I tried to set the cache size to 0 (after sqlite3_open0, and then query
> for pragma cache_size which returns 2000 (default cache size). Why its
> not returning 10 (according to Weiyang Wang)?
It does report 0, even though internally it is using a value of 10.
SQLite version 3.3.17
Enter
Hi,
I want to add an index on a sparsely populated column -
i.e. for most rows the column is null.
1. Would this index be very compact? i.e. only include "set" rows.
2. Could this index also help select NULL entries?
Thanks,
Eliedaat Adler
[EMAIL PROTECTED] wrote:
> > - Original Message
> > From: Joe Wilson <[EMAIL PROTECTED]>
> > To: sqlite-users@sqlite.org
> > Sent: Monday, June 11, 2007 8:36:32 PM
> > Subject: Re: [sqlite] Database replication question
> >
> >
> > Large bulk inserts with more than one index (implicit
[EMAIL PROTECTED] wrote:
- Original Message
From: Joe Wilson <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Monday, June 11, 2007 8:36:32 PM
Subject: Re: [sqlite] Database replication question
Large bulk inserts with more than one index (implicit or explicit)
is not SQLite's
Sebastian Tennant <[EMAIL PROTECTED]>
wrote:
I have three tables; users, propositions, and subscriptions:
users
-
user_id user_name user_password user_email
propostions
---
prop_id proposition user_id
subscriptions
-
sub_id
I tried to set the cache size to 0 (after sqlite3_open0, and then query
for pragma cache_size which returns 2000 (default cache size). Why its
not returning 10 (according to Weiyang Wang)?
Regards,
Phani
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent:
[EMAIL PROTECTED] wrote:
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> > I've opened a new ticket 2409.
> >
> > http://www.sqlite.org/cvstrac/tktview?tn=2409,38
> >
>
> I am so far unable to reproduce the problem. Please send
> me an example corrupt database and the binaries for
>
What exactly happens when I change the cache_size(both increase and
decrease size)? What happens to the data that's there in the result
cache at the time when the instruction PRAGMA cache_size = 0 is
executed? Will there be any memory that will be freed up when I reduce
the size of result cache?
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> I've opened a new ticket 2409.
>
> http://www.sqlite.org/cvstrac/tktview?tn=2409,38
>
I am so far unable to reproduce the problem. Please send
me an example corrupt database and the binaries for
SQLiteCrush.exe. Tnx.
You can send them to me by
"B V, Phanisekhar" <[EMAIL PROTECTED]> wrote:
> I am yet to get answers for the following questions.
>
Weiyang Wang correctly answered your question at
http://www.mail-archive.com/sqlite-users%40sqlite.org/msg25290.html
--
D. Richard Hipp <[EMAIL PROTECTED]>
[EMAIL PROTECTED] wrote:
>
> The table I have is something like
> CREATE TABLE sn2uid(
>sn VARCHAR(100) NOT NULL,
>uid INTEGER NOT NULL,
>PRIMARY KEY (sn)
> );
> CREATE INDEX uidindex on sn2uid ( uid )
>
>
> is there a way to do a select or a .dump so that when inserting the
> data
Hi,
With checking the source code build, i could see DSQLITE_OMIT_DISKIO does
not work properly.
the problem is that symbols, which are related to DSQLITE_OMIT_DISKIO in
btree.c and attach.c, are not properly tied to DSQLITE_OMIT_DISKIO. so
caused linker errors.
best regards,
wang
thanks.
that is correct. i have just found this issue 5 mins ago. i am re-doing the
compiling now.
and .
it works.
thanks. have a nice day
wang
On 6/12/07, Dan Kennedy <[EMAIL PROTECTED]> wrote:
On Tue, 2007-06-12 at 09:56 +0200, weiyang wang wrote:
> Hi Dr.H,
> Yes, I did a clean
On Tue, 2007-06-12 at 09:56 +0200, weiyang wang wrote:
> Hi Dr.H,
> Yes, I did a clean build in a clean directory( (top)/bld ). and i had run
> 'make clean' before i run the 'make'.
>
> i am wondering whether the lemon tool configuration in my environment is
> well done or not.
>
> thanks in
Hi Dr.H,
Yes, I did a clean build in a clean directory( (top)/bld ). and i had run
'make clean' before i run the 'make'.
i am wondering whether the lemon tool configuration in my environment is
well done or not.
thanks in advance.
wang
On 6/11/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi all,
I have three tables; users, propositions, and subscriptions:
users
-
user_id user_name user_password user_email
--- - -
--
U01 mikescott
30 matches
Mail list logo