[sqlite] In-memory DB performance tuning

2003-11-17 Thread Arthur C. Hsu
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

Re: [sqlite] Can we load a db file to RAM ?

2003-11-17 Thread Arthur Hsu
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 ? >

[sqlite] Can we load a db file to RAM ?

2003-11-17 Thread Christian Hamar
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

[sqlite] ANN: SQlite4Delphi 0.4.4

2003-11-17 Thread Michal Zaborowski
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

[sqlite] Ann: SQLite Analyzer v 2.0.0 released

2003-11-17 Thread Sergey Startsev
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. -

Re: [sqlite] Built-in SQL-functions in SQLite (like: to_date, trim, cast, ...) ?

2003-11-17 Thread Derrell . Lipman
"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

[sqlite] Built-in SQL-functions in SQLite (like: to_date, trim, cast, ...) ?

2003-11-17 Thread Fouejieu louis
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*.