env | grep LD_LIBRARY_PATH;
it will display path list. Now use that path and see if your lib is present
there or not in that paht.
If not add the path(where fst2 exists) to LD_LIBRARY_PATH
R u new to unix/linux, i suggest to go through
basic of them.
regrads
Hallo,
found this interesting feature - but I'm not quite sure, how it's working,
and manual doesn't contain a good example.
Perhaps someone using this feature could give me an example, how should it
look like in the case, when I want to:
1. Copy the entire contents of existing database from
Zbigniew Baniewski zb-pij/[EMAIL PROTECTED] wrote:
found this interesting feature - but I'm not quite sure, how it's
working, and manual doesn't contain a good example.
All ATTACH DATABASE command is giving you is the ability to run
statements across database files. There is no magic
On Thu, Sep 06, 2007 at 10:33:56AM -0700, Joe Wilson wrote:
Without some code modification, I doubt it.
I don't see any mention of dot in os_win.c.
However, in SQLite 3.5 you can define your own OS Interface File
Virtual Methods Object and create your own file lock/unlock routines
based
On Sun, Sep 16, 2007 at 07:09:58PM -0400, Igor Tandetnik wrote:
No. You will have to do the same replication process as in #1, only in
the other direction.
Tough luck.
Yes, found an example - maybe someone will be interested too:
On 9/16/07, Zbigniew Baniewski [EMAIL PROTECTED] wrote:
I've found a remark regarding write concurrency in SQLite:
All SQLite write operations obtain an exclusive lock on the whole database
( http://www.mail-archive.com/sqlite-users@sqlite.org/msg18342.html )
Doesn't it mean, that database
On 9/12/07, Stéphane Thiers [EMAIL PROTECTED] wrote:
Somehow I missed replying earlier, sorry about that.
The column which contains these numbers is
declared as REAL. This raises another question to
me: I thought that the numbers were stored as
strings, so why sqlite would try to transform
On Sun, Sep 16, 2007 at 05:47:07PM -0700, Trevor Talbot wrote:
The default locking mechanism relies on the underlying filesystem to
provide the needed locking guarantees. In this case, the OP is
needing to access a database on a networked filesystem, and many
networked filesystems are unable
--- 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 (id PRIMARY KEY, url);
--- Zbigniew Baniewski [EMAIL PROTECTED] wrote:
On Sun, Sep 16, 2007 at 05:47:07PM -0700, Trevor Talbot wrote:
The default locking mechanism relies on the underlying filesystem to
provide the needed locking guarantees. In this case, the OP is
needing to access a database on a networked
But with large cache there is too much fragmentation observered (pgin/pgout)
over a period of time. Do u see this behaviour?
My CacheSize: 32KB, PgSize: 8KB (to the limits)
regards
ragha
**
This email and
--- RaghavendraK 70574 [EMAIL PROTECTED] wrote:
But with large cache there is too much fragmentation observered (pgin/pgout)
over a period of time. Do u see this behaviour?
Fragmentation is not a function of page cache size, but yes,
I also see this fragmentation if the secondary index exists
But there is a limit (3.4.0) which stops at 32KB.
the compile macro would do?
regards
ragha
**
This email and its attachments contain confidential information from HUAWEI,
which is intended only for the
You don't have to recompile.
Just make a new database file with:
pragma page_size=32768;
pragma default_cache_size=[your machine RAM in bytes / 32768];
--- RaghavendraK 70574 [EMAIL PROTECTED] wrote:
But there is a limit (3.4.0) which stops at 32KB.
the compile macro would do?
I did not build sqlite on Solaris 10, but I do build it on Solaris
Express Community Edition successfully.
On Fri, 2007-09-14 at 16:20 +0100, 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
make that:
pragma default_cache_size=[half your machine RAM in bytes / page_size];
--- Joe Wilson [EMAIL PROTECTED] wrote:
You don't have to recompile.
Just make a new database file with:
pragma page_size=32768;
pragma default_cache_size=[your machine RAM in bytes / 32768];
---
16 matches
Mail list logo