> You can load sqlite into memory?
> I do have 2GB of RAM.
You can pass ":memory:" to the sqlite_open command to open a SQLite
database in memory I think it is
I imagine this will speed up your retrievals but without an index it
will still be slower that it should be.
With an index I imagine
I think what you propose will work fine, but you could just
do it all yourself with some SQL. Arguably clearer, and no
messing about with complex, possibly non-portable, triggers +
auto-increments.
/* Initialize system */
BEGIN;
CREATE TABLE id_allocator(id INTEGER);
INSERT INTO id_allocator(0)
You can load sqlite into memory?
I do have 2GB of RAM.
Richar
d
On Thu, 06 Oct 2005 00:04:29 -0400, Lindsay <[EMAIL PROTECTED]> wrote:
Richard wrote:
Still have found no sql program yet, that can beat Panorama in speed.
Since Panorama is RAM based, how about if you did your speed test wi
To find 32.0833 from field A, in Table T
Richard
PS: Nothing is index
On Thu, 06 Oct 2005 01:17:35 -0400, Puneet Kishor <[EMAIL PROTECTED]>
wrote:
On Oct 5, 2005, at 10:57 PM, Richard wrote:
Well, finally import 9,337,681 records into sqlite3 test2.db
and ran the test.
import sqtest
On Oct 5, 2005, at 10:57 PM, Richard wrote:
Well, finally import 9,337,681 records into sqlite3 test2.db
and ran the test.
import sqtest4.txt : 2 min 28 seconds
select A, '32.0833' From T ; 9 min 20 seconds
there is no constraint in the above statement... you are selecting A
(which, I am a
Richard wrote:
Still have found no sql program yet, that can beat Panorama in speed.
Since Panorama is RAM based, how about if you did your speed test with a
SQLite in memory database ?
--
Lindsay
Well, finally import 9,337,681 records into sqlite3 test2.db
and ran the test.
import sqtest4.txt : 2 min 28 seconds
select A, '32.0833' From T ; 9 min 20 seconds
--
I use another database for MacOS X
also works on Windows, Call Panorama
Did another test, comparing database...
import sqtest4
In my app (a perl/web-based on-line training system), I have a table of users
with an integer primary key column, tech_id. The tech_ids are created by a
foreign system, and either imported with other data, or inserted as-received by
my app.
In enhancing the app, I'm finding it desirable to
On Tue, 4 Oct 2005, Martin Engelschalk wrote:
>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.
You'll have to write your own pager layer, as there
Greeting sailendra,
sai kalyanam wrote:
Greetings all,
can you pls any help me how to secure sqlite database. there is no userid and
password to open the database. what are the security issues in SQLite database.
can you pls help in this issue.
You need to encrypt your database.
Dr. H
Hi,
sqlite does not know users. You can restrict access using the file
privileges for the database - file (chown / chmod). If you want
users/passwords in your application, you have to implement this in your
application.
Martin
sai kalyanam schrieb:
Greetings all,
can you pls any help me
Greetings all,
can you pls any help me how to secure sqlite database. there is no userid and
password to open the database. what are the security issues in SQLite database.
can you pls help in this issue.
Thanks
sailendra
-
Yahoo! for Good
12 matches
Mail list logo
