On 17/09/2007 1:07 PM, Joe Wilson wrote:
--- D. Richard Hipp [EMAIL PROTECTED] wrote:
I have been struggling with the performance of insertion in sqlite.
Here we have a very simple case :
A table with an integer autoincrement primary key and a text
field that is
unique.
CREATE TABLE my
On Sun, Sep 16, 2007 at 08:42:44PM -0700, Joe Wilson wrote:
Host a shared database file on computer A, say shared.db.
From computer B, open shared.db remotely and execute BEGIN EXCLUSIVE;.
From computer C, open shared.db remotely and execute BEGIN EXCLUSIVE;.
If computer C has the error SQL
Zbigniew Baniewski [EMAIL PROTECTED] wrote:
On Sun, Sep 16, 2007 at 08:42:44PM -0700, Joe Wilson wrote:
Host a shared database file on computer A, say shared.db.
From computer B, open shared.db remotely and execute BEGIN EXCLUSIVE;.
From computer C, open shared.db remotely and execute
On Mon, Sep 17, 2007 at 02:29:58PM +, [EMAIL PROTECTED] wrote:
http://www.sqlite.org/pragma.html#pragma_locking_mode
Oh, boy... missed entire set of pragma commands. Thanks.
--
pozdrawiam / regards
Zbigniew
On 17 Sep 2007, at 05:58, Halton Huo wrote:
I did not build sqlite on Solaris 10, but I do build it on Solaris
Express Community Edition successfully.
Are you using Sun's compiler or gcc? I guess I could install some
version of Studio on my host if the former...
--tim
On 14 Sep 2007, at 16:20, Tim Bradshaw wrote:
Has anyone successfully got either of these to build on Solaris 10,
using the gcc that ships with it? I've tried on 10u4 on x86 and
(after fixing the known problem with B_FALSE/B_TRUE for 3.4.2) they
both failed sometime while linking. I just
Hello,
I'm having trouble loading fts2. I modified makefile to create fts2
library on Linux/Ubuntu.
When I attempt to load fts2 using the command:
select load_extension('fts2'), i get the error shared library not found.
( noticed that it had not created the .so file, only .la file.)
I do
A.J.Millan [EMAIL PROTECTED] wrote:
Must I use again the complete create sentence to get the desired design in
the new table?
yes.
--
D. Richard Hipp [EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL
To help isolate if it's actually a library path problem, you might try
using the full path. So, instead of:
select load_extension('fts2');
do:
select load_extension('/path/to/libfts2.so');
Modified for Windows as appropriate (sorry, I mostly use Linux and
static linking). If that works,
Hi all:
Suppose a dBase named dBase1 and a table declared in it:
CREATE TABLE 'tb1' (Id INTEGER PRIMARY KEY, Nm INTEGER, Ci INTEGER);
Then, after some inserts I open a new dBase, say dBase2, and duplicate
dBase1.tb1 with the C API functions executing the querys:
ATTACH dBase1 AS
Thank you Nuno and Joe for your help. I have posted a new version, now
called extension-functions.c, which works on external interfaces only and
therefore does not require the sqlite3 source code. I have made everything
a single C file with instructions as a comment at the top, hence no need for
is the fts2 a library?
if so you probably need to put it in a directory that is in the list of
library directory's. You also may need to run ldconfig to update the
dynamic linker as the the whereabouts of your new lib.
use man ldconfig for the how-to
Scott
Uma Krishnan wrote:
Hello,
I'm
As part of doing internationalization work on Gears, it has been
determined that it is unlikely that you can just define a global
tokenizer that will work for everything. Instead, in some cases you
may need to use a specific tokenizer, based on the content being
tokenized, or the source of the
An interesting method is progress:
The progress callback can be used to display the status of a lengthy query
or to process GUI events during a lengthy query.
But I'm not quite sure presently, how it could look like in practice? To make
a progress bar I've got to know a maximal value of the
Zbigniew Baniewski [EMAIL PROTECTED] wrote:
An interesting method is progress:
The progress callback can be used to display the status of a lengthy query
or to process GUI events during a lengthy query.
But I'm not quite sure presently, how it could look like in practice? To make
a
Zbigniew Baniewski wrote:
An interesting method is progress:
The progress callback can be used to display the status of a lengthy query
or to process GUI events during a lengthy query.
But I'm not quite sure presently, how it could look like in practice? To make
a progress bar I've got to
On 9/18/07 5:00 AM, Zbigniew Baniewski [EMAIL PROTECTED] wrote:
An interesting method is progress:
The progress callback can be used to display the status of a lengthy query
or to process GUI events during a lengthy query.
But I'm not quite sure presently, how it could look like
I have used the prepare, step, finalize methods in order to implement the
progress callback and it works fine.
However, I would like to know couple of things.
a. Whether the sqlite3_exec function is better in terms of performance to
receive the callback?
b. Will sqlite3_interrupt function stop
On 17/09/2007, John Machin [EMAIL PROTECTED] wrote:
On 17/09/2007 1:07 PM, Joe Wilson wrote:
--- D. Richard Hipp [EMAIL PROTECTED] wrote:
I have been struggling with the performance of insertion in sqlite.
Here we have a very simple case :
A table with an integer autoincrement primary
19 matches
Mail list logo
