Hi,
Background Info -
1. Using Linux kernel v2.4.21 on both machines.
2. Scenario in which this problem occurs - when I rlogin/rsh to another
machine and then run the app
calls to sqlite3_open() work successfully
calls to sqlite3_exec() return 'database is locked' error message
3. This
Another question... Does Monotone still Base64 encode all its data before
putting it into blobs?
If so, using raw binary SQLite blobs would likely give Monotone a 33% speedup
and smaller
database.
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> Does Monotone spend most of its database time in a few
Does Monotone spend most of its database time in a few long running queries or
thousands of
sub-second queries?
Could you point us to an example monotone database tarball and give some actual
examples of
speed-deficient queries?
When working with large SQLite databases with blobs I generally fi
deBooza (sent by Nabble.com) wrote:
Hi
I'm using sqlite in a c++ program, using functions sqlite3_open, sqlite3_exec,
sqlite3_close etc.
I am trying to import a lot of data, probably around 100,000 rows+. I have
found it
quicker if I format the data into SQL statements and then use
the shell
> >We have an existing Sqlite application which till now was
> fine running
> >on single machine. Now we need flexibility of client server
> model. Is
> >this possible with Sqlite ? . Or alternatively is it possible to use
> >Sqlite db file from shared drives.
>
> You can use SQLRelay from ht
> Hello,
> I have a question regarding sqlite's behavior when auto commit is disabled.
>
> I have two conflicting transactions, A & B, where A is started first.
> B starts by executing some SELECT queries (which all succeed), then on
> the first UPDATE I get SQLITE_BUSY (as A is holding a conflicti
At 07:50 01/02/2006, you wrote:
Dear All,
We have an existing Sqlite application which till now was fine running
on single machine. Now we need flexibility of client server model. Is
this possible with Sqlite ? . Or alternatively is it possible to use
Sqlite db file from shared drives.
You can
Hello,
I have a question regarding sqlite's behavior when auto commit is disabled.
I have two conflicting transactions, A & B, where A is started first.
B starts by executing some SELECT queries (which all succeed), then on
the first UPDATE I get SQLITE_BUSY (as A is holding a conflicting
lock). I
No bugs, just "benign" warnings.
btree.c
.\Sqlite\v3\btree.c(432): remark #1418: external definition with no prior
declaration
int sqlite3_btree_trace=0; /* True to enable tracing */
^
This variable is only used here and in test3.c.
I guess it should be enclosed between the #if SQLITE_T
> I'm using sqlite in a c++ program, using functions sqlite3_open,
> sqlite3_exec, sqlite3_close etc.
>
> I am trying to import a lot of data, probably around 100,000 rows+. I have
> found it
> quicker if I format the data into SQL statements and then use
> the shell statement .read to read in th
Something related, but that doesn't really answer the question: if you
want to populate a database with so many rows, to speed up things a lot
you should embed them into a transaction (or in a small number of
transactions). This way, if sqlite works synchronously, it doesn't need to
flush data
Hi all,
I compiled a static library with dev-cpp out of the sqlite_src-package
from the homepage. No error or warning occured but...
when I use my compiled library instead the one out of the
dev-cpp-package the program aborts without any error message.
Why?
Thanks!
Daniel
Hi
I'm using sqlite in a c++ program, using functions sqlite3_open, sqlite3_exec,
sqlite3_close etc.
I am trying to import a lot of data, probably around 100,000 rows+. I have
found it
quicker if I format the data into SQL statements and then use
the shell statement .read to read in the SQL f
On Tue, 31 Jan 2006 [EMAIL PROTECTED] wrote:
>Robert Tortajada <[EMAIL PROTECTED]> wrote:
>> >
>> The bad return from fsync is -1 so I am not sure that will be helpfull.
>> However, couldn't we just disable DIRSYNC since that seems to be the issue?
>>
>
>Yeah. Just disable DIRSYNC. This will sli
I use a program which converts a simple SQL result into XML. It is just
a C program calling Sqlite. You are welcome to a copy if it would help you.
JS
pavan savoy wrote:
-- Forwarded message --
From: pavan savoy <[EMAIL PROTECTED]>
Date: Jan 31, 2006 7:17 PM
Subject: Does SQLi
Nathaniel Smith <[EMAIL PROTECTED]> wrote:
> I was wondering if there were any docs or explanations available on
> how SQLite decides to lay out data on disk.
Free pages in the middle of the file are filled first. Some effort
is made to uses pages that are close together for related information.
For original announcement with links see
http://kexi-project.org/wiki/wikiview/index.php?1.0Beta1Announcement
---
Kexi Team Ships Beta Version of the First Major 1.0 Release to Free
Integrated Database Environment
Jan
Hello,
I was wondering if there were any docs or explanations available on
how SQLite decides to lay out data on disk.
The context is the monotone project -- http://venge.net/monotone --
a VCS where we store project history in a sqlite database. Sqlite has
been _very_ good to us, and we'd rather
Hi,
Vishal Kashyap wrote:
Dear All,
We have an existing Sqlite application which till now was fine running
on single machine. Now we need flexibility of client server model. Is
this possible with Sqlite ? . Or alternatively is it possible to use
Sqlite db file from shared drives.
--
With Best
Carl Jacobs wrote:
>
> > > All would be fine but look at this :
> > >
> > > create table test(
> > > price double,
> > > amount double default 0
> > > );
> > >
> > > insert into test(price) values("12,0");
> > >
> > > amount now = 0.0
>
> The world seems to have settled on using Arabic numerals 0
Vishal Kashyap wrote:
Dear All,
We have an existing Sqlite application which till now was fine running
on single machine. Now we need flexibility of client server model. Is
this possible with Sqlite ? . Or alternatively is it possible to use
Sqlite db file from shared drives.
Don't know if thi
21 matches
Mail list logo