Hello,
I have an in-memory DB and try to perform inserts to tables inside. Seems
that there are some performance bottlenecks for continuous inserts. The row
insertion speed will drop dramatically after the first 6000 rows are
inserted. That is
Time ElapsedRows inserted
Open db file with the name ":memory:" (without the quotes).
This gives you an in-mem database.
-Arthur
- Original Message -
From: "Christian Hamar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 1:41 PM
Subject: [sqlite] Can we load a db file to RAM ?
>
Hi there.
My question. Can i load an sqlite db file to RAM to work the things
faster ? Especially to load the file first to some variable and then
open it in ram. And work from the ram ?
I need some C and linux ideas.
Any idea for this ?
Best Regards:
Christian Hamar alias kRiX
Hello,
As in topic - new release.
Many bugs fixed, better stability.
Please test and comment.
--
Regards,
Michal Zaborowski (TeXXaS)
http://sqlite4delphi.sourceforge.net/
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
Hello!
SQLite Analyzer v 2.0.0 released
What's new in the version 2.0.0
- Visual table creating and modifying (add/change/delete columns,
constraints etc) without data loss.
- Query interrupting.
- Database structure (tables, views, columns, types, indexes) displays
in a tree.
-
"Fouejieu louis" <[EMAIL PROTECTED]> writes:
> where can I find documentation about built-in SQL-functions in SQLite (like:
> to_date, trim, cast, ...) ?
Google for "sqlite". The very first entry takes you to the home page. Look
for the entry for "Supported SQL language" (or some such), and
Hi folks,
where can I find documentation about built-in SQL-functions in SQLite (like:
to_date, trim, cast, ...) ?
Thanks
Louis
_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
7 matches
Mail list logo