do we usually do:
open db-some operation with db-close db.
or keep the db handle with the thread and use it all
the time?
i am asking this mainly because of possible error
conditions. when an error happens, is it better to
close the database and reopen it later? i am going to
lock the handle
Hello René Tegel,
May i add to that that 'order by' also seems involved, see below. This can
lead to really unexpected errors... order by 1.0 * b / c as workaround
solves it btw.
Thanks for pointing this out.
I am sure we will be able to come up with even more examples where the
confusion of
Can someone out there advise me as to why SQlite needs to perform so many
writes to disk when executing an insert.
The insert consists of 6 columns. There is a total of 5 indexes on the table.
The average size of one of these records is around 800 bytes. We have an SQlite
page size of 1024
Interesting tool. Are sources available for porting to other
OSes? I would like to try on FC4.
--
G. Roderick Singleton [EMAIL PROTECTED] PATH tech
unfortunately not, as it uses a lot of commercial components. plus, it
is Delphi :)
Hi,
On Mon, Oct 03, 2005 at 11:16:12AM -0400, [EMAIL PROTECTED] wrote:
I also added code to deallocate the hash tables when their size
reaches zero. [...]
Thanks a lot.
I am sure this is worth the overhead and makes sqlite an even better piece
of software.
yours,
- clifford
--
_ _
jack wu [EMAIL PROTECTED] wrote:
do we usually do:
open db-some operation with db-close db.
or keep the db handle with the thread and use it all
the time?
i am asking this mainly because of possible error
conditions. when an error happens, is it better to
close the database and
Mark Allan [EMAIL PROTECTED] wrote:
Can someone out there advise me as to why SQlite needs to perform
so many writes to disk when executing an insert. The insert consists
of 6 columns. There is a total of 5 indexes on the table. The average
size of one of these records is around 800 bytes.
Thanks alot for this information.
We have disabled the writing of data to the rollback journal file before
writing to the database (could this account for 10 writes instead of 12?). We
did this to speed up the write to the database, which it has. It would seem
from your email that this could
Hi all,
it may sound strange, but I do not need transactions. Also i do not
care if the database is corrupted in case of a program or system crash.
So: is it possible to disable transactions in sqlite? Mr. Mark Allan
semms to have done this. Could i speed up my writes this way?
Thanks,
Hi all,
it may sound strange, but I do not need transactions. Also i do not
care if the database is corrupted in case of a program or system crash.
So: is it possible to disable transactions in sqlite? Mr. Mark Allan
seems to have done this. Could i speed up my writes this way?
Thanks,
On Mon, 3 Oct 2005, Thomas Briggs wrote:
Given my understanding of the codebase (you get to decide what that's
worth), the value of the synchronous pragma determines decisions going
forward, so changing it mid-process should impact only transaction
handling from that point forward. I do
On Sat, 1 Oct 2005, denys wrote:
Hi all,
I'm trying to create a table but I always get an assertion failed
crash :-(
Addressed by others ...
Here is the statement:
CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original
INTEGER, used INTEGER, picture TEXT, note INTEGER, comment
However, as SQLite files are single files, a crash during a
non-important
transaction could still hose the entire database. In this
sense, there is
no such thing as a non-important transaction.
Hrm... A very good point. Thanks for spotting the flaw in my
thinking. :)
-Tom
On Tue, 4 Oct 2005, Martin Engelschalk wrote:
Hi all,
it may sound strange, but I do not need transactions. Also i do not
care if the database is corrupted in case of a program or system crash.
So: is it possible to disable transactions in sqlite? Mr. Mark Allan
seems to have done this. Could i
Hello Christian,
thank you, but synchronous is already off. What i aim to avoid is
writing the rollback - journal. In order to rollback, some additional
writing to disk is surely unaviodable.
Martin
Christian Smith schrieb:
On Tue, 4 Oct 2005, Martin Engelschalk wrote:
Hi all,
it
On 10/4/05, Christiane Lemke [EMAIL PROTECTED] wrote:
I try to update a row of a Sqlite3 Database with the c++ api using the
following lines of code:
char dbquery[1024];
int rc;
sprintf(dbquery, update zeit_tabelle set zeit = %d where username like
'%s';, 12345, test);
rc =
On 10/3/05, Bryan J. Smith [EMAIL PROTECTED] wrote:
We're building a multi-master, peer-to-peer network service,
so we need a way to replicate changes between systems.
Before finding SQLite, I figured I'd have to write an
all-in-one daemon. E.g., an application that handles the
app's data
Christiane Lemke [EMAIL PROTECTED] wrote:
Hello,
I try to update a row of a Sqlite3 Database with the c++ api using the
following lines of code:
char dbquery[1024];
int rc;
sprintf(dbquery, update zeit_tabelle set zeit = %d where username like
'%s';, 12345, test);
rc = sqlite3_exec(db,
Am 29.09.2005 um 17:40 schrieb Martin Pfeifle:
Hi,
does anybody know whether a code example for
User-defined Collating Sequences in C exists, and
where I can find such an example.
Check out func.c in the sqlite source distribution - it contains the
implementations of the built-in collation
Am 01.10.2005 um 06:58 schrieb Richard Nagle:
Well,
Did this:
sqlite3 test2.db
create Table T (A, B, C );
.separator ,
.import 'sqtest2.txt' T
It looks like it working, but the file size is still
4K and not 170 Megs.
Please note:
I exported this database as a Tab delimiter
You gave no details.
Did you open the database first?
All right, I'm sorry, here is a more complete code snip to illustrate my
problem:
sqlite3 * db;
rc = sqlite3_open(test.db, db);
if(rc) {
fprintf(stderr, Can't open database: %s\n, sqlite3_errmsg(db));
exit(1);
}
rc = sqlite3_exec(db,
Are you *sure* the database is an SQLite3 database and not an SQLite2
database?
No, I'm not, I have to use a database created somewhere else. How can I
tell?
Anyway, I can open and read the database without any problems with the
sqlite3 C++ API, just modifying does not seem to work.
I can
Christiane Lemke [EMAIL PROTECTED] wrote:
Are you *sure* the database is an SQLite3 database and not an SQLite2
database?
No, I'm not, I have to use a database created somewhere else. How can I
tell?
Anyway, I can open and read the database without any problems with the
sqlite3 C++
make sure your /tmp directory is writable. Also make sure you
are able to create new files in the directory that contains the
database file itself.
That's it! I did not know that one has to be able to create files in the
directory with the database, I thought the right permissions on the
Well,
Did this:
sqlite3 test2.db
create Table T (A, B, C );
.separator ,
.import 'sqtest2.txt' T
It looks like it working, but the file size is still
4K and not 170 Megs.
Please note:
I exported this database as a Tab delimiter file,
then as a Comma, delimiter file...
** Got it to import,
Richard,
No loop commands on your part are needed.
Did you receive Jens Miltner's post of 9:55am (UTC-4hr)? Was it relevant?
---
Are you sure your text file has the correct line-endings? From a quick look
at the shell sources, it looks like the shell expects native
I have a database (encrypted w/ encryption extensions from drh). After
run a sql file on this database it gives the error SQL error: SQL
logic error or missing database after running a vacuum. it also seems
to give this error sporadically on other statements.
the sql file that i run does the
Hi Don,
No, I did not received, any email from Jens Miltner's
in fact, I notice, that posting from the sqlite list, are becoming
very sparse in coming there are hours of gaps
sometime nothing for a day.
Regards-
Richard
On Tue, 04 Oct 2005 11:26:32 -0400, Griggs, Donald
[EMAIL
as a matter of fact, I have also noticed that using the vaccum command
from the command-line interface does bring this error up sometimes.
however, since I use the graphical UI most of the time (being its
author:) I don't use the command line interface that much.
I suspect it has nothing to do
Jay Sprenkle [EMAIL PROTECTED] wrote:
You're still going to have to understand locking semaphores
and threads.
Yeah, I was thinking about that.
There are still structures in memory and other access issues.
All sqlite does for you is give you a good interface
to access the data, transactions,
Well, based on your comment i tried a vacuum from the API and i still get
the error.
Original Message Follows
From: Cariotoglou Mike [EMAIL PROTECTED]
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] SQL logic error when running vacuum;
Date: Tue, 4
Regarding: Hi Don,
No, I did not received, any email from Jens Miltner's in fact, I notice,
that posting from the sqlite list, are becoming very sparse in coming
there are hours of gaps
sometime nothing for a day.
I don't think it's unusual for there to be day-long gaps. Others may know
Hi Don,
This what the text data contains, form importing
-180,90,NaN ( carriage return )at the end of each record. ( nothing else. )
-179.917,90,NaN
-179.833,90,NaN
-179.75,90,NaN
-179.667,90,NaN
-179.583,90,NaN
-179.5,90,NaN
-179.417,90,NaN
-179.333,90,NaN
-179.25,90,NaN
-179.167,90,NaN
Richard wrote:
Hi Don,
This what the text data contains, form importing
-180,90,NaN ( carriage return )at the end of each record. ( nothing
else. )
-179.917,90,NaN
-179.833,90,NaN
. . .
Richard,
Here is a copy of Puneet Kishor's reply to you from yesterday.
On Oct 3, 2005, at 11:44
Hi,
I'm working on integrating sqlite into Mozilla. The problem is that
some Linux users have their profile (and hence, database) over a
network. Ignoring the safety issues for a moment, I'm trying to get
good performance. Sometimes it takes the network a while to read a
page, so I'm trying to
Brett Wilson [EMAIL PROTECTED] wrote:
Hi,
I'm working on integrating sqlite into Mozilla. The problem is that
some Linux users have their profile (and hence, database) over a
network. Ignoring the safety issues for a moment, I'm trying to get
good performance. Sometimes it takes the network
36 matches
Mail list logo