On 10/31/06, Zimmer András <[EMAIL PROTECTED]> wrote:
I have a set of programs that use SQLite3 as a buffer (and an archive at
the same time). One process (the "feeder") generates some data and puts
it into an SQLite3 DB. (It opens the DB on its own, stores its own
sqlite3 structure, etc.)
Hi,
I am trying to analyze index usage for my queries for performance.
Basically I found two methods,
One of them EXPLAIN QUERY METHOD.
And the other is idxChk tool.
My DB is of latest version of 3.3.8.
When I checked for idxChk tool page it says it was tested only till 3.2.7. Just
wanted
=?ISO-8859-2?Q?Zimmer_Andr=E1s?= <[EMAIL PROTECTED]> wrote:
>
> However, at random times I keep getting "library routine called out of
> sequence" errors (in the feeder).
This is the SQLITE_MISUSE error. You can grep for SQLITE_MISUSE
in the source code to find all the cases where this error
chetana bhargav <[EMAIL PROTECTED]> wrote:
>
> And regarding EXPLAIN QUERY METHOD, I seem to be getting some error. It just
> says,
>
> "0|0|TABLE table_acc WITH INDEX IDX_ACC_ID_STATE"
>
This is not an error. It is the output of EXPLAIN QUERY PLAN.
This says that you are reading the table
Jonas Sandman <[EMAIL PROTECTED]>
wrote:
That was exactly it! I've had seven before but my select hasn't been
correct before. Now when I added path as the seventh parameter it
worked. I have path twice since the first six is bound to query (what
you search for) and the seventh is used to only
DBTools Software is pleased to announce the new DBManager Standard Edition.
This is a bug fix with some new features and improvements.
New Features and Improvements
a.. Better support for SQlite Unicode databases
b.. Now the Freeware Edition can load as many servers as available (1
Database
Thank you Igor, that works great.
Is there a FAQ or page somewhere that would help me understand how
inter-table comparisons like this work? I'd like to be able to do more
of them (without asking for help if possible).
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
=?ISO-8859-2?Q?Zimmer_Andr=E1s?= <[EMAIL PROTECTED]> wrote:
>
> Maybe my mistake but I haven't found a notice in the docs that says I
> mustn't use SQLite from within a signal handler... Is there any known
> workaround to this?
>
A single handler is like a separate thread. You can call
Is there a good way to copy a memory db to disk, when that memory db
uses the FTS1 module?
I've got code that uses a memory db, then copies it to disk. I use the
trick of copying the schema to disk with this:
diskdb transaction {
memdb eval {SELECT sql FROM sqlite_master WHERE sql NOT
A single handler is like a separate thread.
OK, this way I've got it. I ain't a weaver :-)
You can call SQLite from within a single handler
as long as the same database
connection is not being used by the main thread when the single
handler is invoked.
It is supposedly so but the next
OK, the code I have does not do any multithreading.
I do, actually, use SQLite from within a signal handler: the timer
interrupt (SIGALRM handler), and also to close the DB when I catch quit
signals (like SIGINT, SIGHUP, SIGTERM) -- but that's not where the
problem comes from. (The rest on
On 10/30/06, Joe Wilson <[EMAIL PROTECTED]> wrote:
If you have only one index, then pre-sorting your large datasets prior to
inserting with the default sqlite cache will yield twice as good insert
performance as not pre-sorting your data and using a huge cache.
This stands to reason since you're
Hi,
Can I know how is the field datatype on callback function?
If not, can i know in other way??
ty,
Ruben
--
Linux user #433535
Linux because we are freedon.
Rúben Lício <[EMAIL PROTECTED]> wrote:
Can I know how is the field datatype on callback function?
If not, can i know in other way??
Instead of sqlite3_exec, use sqlite3_prepare / sqlite3_step /
sqlite3_finalize. You can then use sqlite3_column_decltype and
sqlite3_column_type.
Igor
I was try sqlite3_prepare, but it's not at my header.
i'm using linux ubuntu 6. sqlite was instaled from official repositories.
i will try decltype and column_type now.
ty,
ruben
On 10/31/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Rúben Lício <[EMAIL PROTECTED]> wrote:
> Can I know how
i have some code which uses sqlite heavily. every so often a command using
with hang indefinitely, running an strace on the code shows it to be stuck in
a loop doing
munmap addr1
mmap #=> addr1
munmap addr2
mmap #=> addr1
munmap addr1
...
...
repeat forever...
[EMAIL PROTECTED] wrote:
> i have some code which uses sqlite heavily. every so often a command using
> with hang indefinitely, running an strace on the code shows it to be stuck in
> a loop doing
>
>
>munmap addr1
>mmap #=> addr1
>munmap addr2
>mmap #=> addr1
>
Hello, somebody know why the tilde do not show correctly.
I am using Turbo Delphi and the unit SQLiteTable3 for access to the
database in sqlite 3, but, the text that I see is, for example:
Calcula la media móvil simple
it must be
Calcula la media móvil simple
Thanks
On Tue, 31 Oct 2006 [EMAIL PROTECTED] wrote:
I suspect that the /var/tmp file is unrelated to your mmap/munmap problem.
When SQLite needs a temporary file on Unix, it creates the file, opens it,
then calls unlink(). Unix removes the inode for the file from its directory
immediately so that
[EMAIL PROTECTED] wrote:
Hello, somebody know why the tilde do not show correctly.
I am using Turbo Delphi and the unit SQLiteTable3 for access to the
database in sqlite 3, but, the text that I see is, for example:
Calcula la media móvil simple
it must be
Calcula la media móvil simple
i can do it now, ty.
i was using sdlite3_compile how i see in one tutorial, but it dont exists,
the correct name is prepare.
regards,
ruben
On 10/31/06, Rúben Lício <[EMAIL PROTECTED]> wrote:
I was try sqlite3_prepare, but it's not at my header.
i'm using linux ubuntu 6. sqlite was
> [EMAIL PROTECTED] wrote:
>> Hello, somebody know why the tilde do not show correctly.
>> I am using Turbo Delphi and the unit SQLiteTable3 for access to the
>> database in sqlite 3, but, the text that I see is, for example:
>>
>> Calcula la media móvil simple
>>
>> it must be
>>
>> Calcula la
Hi again,
I'm with other problem, in linux is all perfect here, BUT
i cannot compile any sqlite in windows.
I'm using Visual C++ Express Edition 2006 with windows XP.
The error is referent of sqlite lib. MSVC dont know sqlite function as dont
have correct include, but it there.
I was find in
Hello Rúben,
Tuesday, October 31, 2006, 3:51:05 PM, you wrote:
RL> Hi again,
RL> I'm with other problem, in linux is all perfect here, BUT
RL> i cannot compile any sqlite in windows.
RL> I'm using Visual C++ Express Edition 2006 with windows XP.
RL> The error is referent of sqlite lib. MSVC
Rúben Lício wrote:
Hi,
Can I know how is the field datatype on callback function?
If not, can i know in other way??
ty,
Ruben
If you use sqlite3_prepare and sqlite3_step you can call the API
functions which give you the decalred and actual type.
Does anyone know if :memory: databases still use a cache? We are using Sqlite
in a game and are very tight on memory. I'm wondering if it would be good for
us to reduce the cache size to 0 (or something very small), and if there would
be any performance penalty for doing so. It seems like
On 01/11/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
My efforts to contact Mcafee about this problem have
been unfruitful.
Does anybody have an suggestions on how I might deal
with this?
You could trademark the name SQLite and have a lawyer send them a
letter. Companies respond much
[EMAIL PROTECTED] wrote:
Does anybody have an suggestions on how I might deal
with this?
The usual approach is to write a web page about it and then publish a
story on Slashdot. That will get the requisite people's attention as
well as ensuring highly prominent search results for anyone
On Tue, 31 Oct 2006 [EMAIL PROTECTED] wrote:
I need advice from the community. The problem
is seen here:
http://www.sqlite.org/cvstrac/tktview?tn=2049
http://www.sqlite.org/cvstrac/tktview?tn=1989
http://www.sqlite.org/cvstrac/tktview?tn=1841
[EMAIL PROTECTED] wrote:
> > My efforts to contact Mcafee about this problem have
> > been unfruitful.
McAfee aren't playing fair. :( How about putting that explanation on a
page on your site with a link to the support at McAfee so they can
complain directly to the real culprits?
I suppose
[EMAIL PROTECTED] wrote:
> On Tue, 31 Oct 2006 [EMAIL PROTECTED] wrote:
> >
> > http://www.sqlite.org/cvstrac/tktview?tn=2049
> >
> > Does anybody have an suggestions on how I might deal
> > with this? Does anybody know how I can get in touch
> > with an engineer at Mcafee so that we can at
Actually, just by following the links on your web site I was able to find
a forum post from a McAfee employee suggesting that they were going to
change the naming of the temp files, or were at least considering it.
Check the last message in the forum posting that you have linked from the
wiki
[EMAIL PROTECTED] said:
> Now, I just have to figure out how to get Mcafee to upgrade
> to the latest version of SQLite and recompile
I think you need to contact this fellow:
David Juche
Development Manager
McAfee Master Installer/Download Manager
I don't have an email address, but you
[EMAIL PROTECTED] wrote:
Now, I just have to figure out how to get Mcafee to upgrade
to the latest version of SQLite and recompile
I posted a summary to Slashdot, so hopefully it won't be too hard. I
hope you're not offended but I was rather annoyed that a company which
is using your
Roger Binns wrote:
[EMAIL PROTECTED] wrote:
Does anybody have an suggestions on how I might deal
with this?
The usual approach is to write a web page about it and then publish a
story on Slashdot. That will get the requisite people's attention as
well as ensuring highly prominent search
Dennis Cote <[EMAIL PROTECTED]> wrote:
> Roger Binns wrote:
> >
> > The usual approach is to write a web page about it and then publish a
> > story on Slashdot.
> >
> I have to second this idea. It worked well for Poul-Henning Kamp.
>
OK. Thanks everybody for your support. But let's try to
On Tue, 31 Oct 2006 [EMAIL PROTECTED] wrote:
Dennis Cote <[EMAIL PROTECTED]> wrote:
Roger Binns wrote:
The usual approach is to write a web page about it and then publish a
story on Slashdot.
I have to second this idea. It worked well for Poul-Henning Kamp.
OK. Thanks everybody for
[EMAIL PROTECTED] wrote:
On Tue, 31 Oct 2006 [EMAIL PROTECTED] wrote:
I need advice from the community. The problem
is seen here:
http://www.sqlite.org/cvstrac/tktview?tn=2049
http://www.sqlite.org/cvstrac/tktview?tn=1989
http://www.sqlite.org/cvstrac/tktview?tn=1841
With the bigger companies, like McAfee, the phone support people are often not
employees at the companies they represent. Phone support these days is largely
outsourced.
The first level tech you get usually does triage from a script. If you get to
a second level (or higher) tech, they are
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
On Tue, 31 Oct 2006 [EMAIL PROTECTED] wrote:
http://www.sqlite.org/cvstrac/tktview?tn=2049
Does anybody have an suggestions on how I might deal
with this? Does anybody know how I can get in touch
with an engineer at Mcafee so that we can at
Even better - name the temp file prefix msaccess_ and no one
will dare touch it or question it.
- Original Message
From: James Berry <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Tuesday, October 31, 2006 6:14:11 PM
Subject: Re: [sqlite] SQLite and McAfee Anti-Virus
On Oct 31,
Why not make it McAfee and direct the complaints to the culprits?
Joe Wilson wrote:
Even better - name the temp file prefix msaccess_ and no one
will dare touch it or question it.
- Original Message
From: James Berry <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Tuesday,
I believe I overwrote my Fedora Core 5 version of sqlite (that's
3.3.3-1.2.x86_64) for the second time this year. I downloaded
sqlite-3.3.8 and compiled it with this configure string:
../configure --prefix=/usr/local/sqlite-3.3.8 --libdir=/usr/lib64
--includedir=/usr/include --disable-tcl
On Tue, 31 Oct 2006, [EMAIL PROTECTED] wrote:
and it leaves lots of files in C:/TEMP that contain
SQLite in their names. This annoys many windows users.
My efforts to contact Mcafee about this problem have
been unfruitful.
CentOS had a run in with this high degree of intellectual
I would actually remove the default or use the process name instead.
Just my $0.02.
Mike
-Ursprüngliche Nachricht-
Von: John Stanton [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 1. November 2006 01:28
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] SQLite and McAfee Anti-Virus
Why
45 matches
Mail list logo
