Am 18.09.2007 um 19:26 schrieb [EMAIL PROTECTED]:
Michael Plagge <[EMAIL PROTECTED]> wrote:
Just for interest: Am I the only one being faced with the quoted
situation and did I not understand the documentation, or is there
some misbehaviour in sqlite's handling of multiply attached database
f
I accidently ran into this situation and spent a couple of hours for
finding the cause. In our environment we have a list of modules ->
databases assignments. As it is possible that some modules share the
database, they point to the same file. So we are attaching each
module's database and
-ldl -lpthread
(at least in my last builds)
On 9/18/07, Olaf Beckman Lapré <[EMAIL PROTECTED]> wrote:
>
> I'm trying to compile the amalgamation on Xubuntu Linux with G++ but I'm
> getting linking errors: several about pthread and others about dlopen() etc.
>
> Is there anything I need to add (li
I'm trying to compile the amalgamation on Xubuntu Linux with G++ but I'm
getting linking errors: several about pthread and others about dlopen() etc.
Is there anything I need to add (libraries, includes, defines) to get it to
compile?
Kind regards, Olaf
[Input == great!]
Regarding space usage, my current prototype stores an additional
column on %_content, defined like 'tokenizer TEXT DEFAULT NULL'. If
NULL, the default tokenizer is used and the per-row cost is
negligible. Otherwise, it is the string specifying the tokenizer,
which I would
I've realized that this proposal does not easily allow for tables
without per-row tokenizers. I think that modifying the create syntax
to be like:
CREATE VIRTUAL TABLE t USING fts3(TOKENIZER DEFAULT , ...);
could handle that. If you use "TOKENIZER ", then you get
the current behaviour, with a f
Hello!
Currently i am working on my diploma thesis and i would
really appreciate your help. I want to simulate a wireless network using
ns2.
I want each node to have a database. So i would like to ask you if i can
combine ns2 with a database such as sqlite.
Have you tried anything similar? Is ther
I see the same behavior--begin exclusive causes db locked error when same db
is attached twice. However, why would you want to attach the same database
twice?
SQLite version 3.4.2
Enter ".help" for instructions
sqlite> attach 'c.dat' as c1;
sqlite> attach 'c.dat' as c2;
sqlite> begin exclusive;
Michael Plagge <[EMAIL PROTECTED]> wrote:
> Just for interest: Am I the only one being faced with the quoted
> situation and did I not understand the documentation, or is there
> some misbehaviour in sqlite's handling of multiply attached database
> files?
>
You are probably the only person
Just for interest: Am I the only one being faced with the quoted
situation and did I not understand the documentation, or is there
some misbehaviour in sqlite's handling of multiply attached database
files?
Thanks
Michael
Am 15.09.2007 um 19:43 schrieb Michael Plagge:
Dear group,
regard
100% CPU is optimal. The less than 100% numbers indicate that the
performance is limited by waits on disk access. When all the data is in
memory disk access would cease and no longer be a bottleneck.
RaghavendraK 70574 wrote:
Why is the CPU shot up by 100% (relative)when the full db is in me
Gary G Allen wrote:
Hello Everyone in SQLite land.
I am totally new to the sites and sounds here.
I have a issue. I hope you can help me with.
I downloaded source code from:
http://www.sqlite.org/download.html
sqlite-3_4_2.zip
(179.14 KB)
Ran the makefile and everything worked fine.
I ha
Why is the CPU shot up by 100% (relative)when the full db is in mem? This can
be a concern.I understand there is not much i/o but 100% is too high.
regards
ragha
**
This email and its attachments contain con
The bash script below attempts to quantify the relationship between
SQLite (3.5.0 alpha) page_size and cache_size towards the speed of
populating a large table with many indexes.
First some rough metrics on the final populated database:
The database is approximately 208M in size, consisting of a
Hello Everyone in SQLite land.
I am totally new to the sites and sounds here.
I have a issue. I hope you can help me with.
I downloaded source code from:
http://www.sqlite.org/download.html
sqlite-3_4_2.zip
(179.14 KB)
Ran the makefile and everything worked fine.
I have been trying to run t
If you only need Windows compatibility you can use the System.Data.SQLite
port. It's made for ADO.NET but it is also binary compatible with SQLite
and can be used from C code. It includes Windows-specific encryption and is
free.
http://sqlite.phxsoftware.com/
With the ADO.NET stuff it's larger
"Simon Davies" <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> Is this expected behaviour (pre-compiled windows binary)?
>
http://www.sqlite.org/cvstrac/tktview?tn=2652
--
D. Richard Hipp <[EMAIL PROTECTED]>
-
To unsubscribe
We have considered this option carefully in the last few years (since we
love SQLite and would love to support it), but $2000 was too expensive
for us at the time... :-(
[EMAIL PROTECTED] escreveu:
You could purchase a license for the SQLite Encryption Extension
(http://www.hwaci.com/sw/sqlite
John Stanton <[EMAIL PROTECTED]> wrote:
> I haven't looked at how Sqlite manages its cache, so my suggestion may
> be irrelevant but we have had success in such a cacheing situation by
> crafting the cache with pages organized in most recently used order.
> The least recently used pages is the o
=?ISO-8859-1?Q?Lu=EDs_Santos?= <[EMAIL PROTECTED]> wrote:
> Hi, people
>
> We have managed to add a simple obfuscation layer to SQLite on windows
> platform; this has been working since version 3.0.8, but We've found a
> problem on the last versions.
>
> We've introduces a simple stream criptog
[EMAIL PROTECTED] wrote:
"Paul Harris" <[EMAIL PROTECTED]> wrote:
A thought along the same lines, can sqlite create a unique index that
is hash-based? this would provide the UNIQUE support, but it wouldn't
provide a sorted index.
That should resolve the massive-insert-too-slow problem, and
a
Hi, people
We have managed to add a simple obfuscation layer to SQLite on windows
platform; this has been working since version 3.0.8, but We've found a
problem on the last versions.
We've introduces a simple stream criptography layer on two functions on
/os_win.c/ (winRead and winWrite).
"Paul Harris" <[EMAIL PROTECTED]> wrote:
>
>
> A thought along the same lines, can sqlite create a unique index that
> is hash-based? this would provide the UNIQUE support, but it wouldn't
> provide a sorted index.
>
> That should resolve the massive-insert-too-slow problem, and
> afterwards he
Hi All,
Is this expected behaviour (pre-compiled windows binary)?
SQLite version 3.4.2
Enter ".help" for instructions
create table monthNames( shortName TEXT, longName TEXT );
insert into monthNames values( 'Jan', 'January' );
insert into monthNames values( 'Feb', 'February' );
insert into monthN
On Tue, 18 Sep 2007 15:18:27 +0530, you wrote:
>All,
>
>
>
>Is there any API in sqlite3 which will provide the Primary keys of the table
>and also the Non-primary keys of the table?
Here is something to start with:
SQLite v3.4.2
CREATE TABLE persons(
person_id INTEGER PRIMARY KEY NOT NU
All,
Is there any API in sqlite3 which will provide the Primary keys of the table
and also the Non-primary keys of the table?
Like suppose I have a table
create table t1 (c1 char, c2 char, c3 char, primary key(c1,c3));
And in my application, I need to know the columns which are the
Hello Scott Hess,
>In the interests of not committing something that people won't like, my
>current proposal would be to add an implicit TOKENIZER column, which will
>override the table's default tokenizer for that row.
There are a few things I am worried about with this approach:
1. FTS stor
Hi,
1.If I choose In memory method, will it be possible for me to insert the
records into the database file?
2. If i choose Disk I/O method can I use temp buffer for searching the
records and also can I insert the records at the same time.
Best Regards,
A.Sreedhar.
28 matches
Mail list logo
