RE: [sqlite] SQLite performance with mid-size databases

2004-06-16 Thread Richard Kuo
Tim, We have been running into many issues with corrupt MDAC installations. Switching to SQLite fixed this admirably. However, database access is now visibly slower for all our users. I have been paying careful attention to use only one index in queries and to make very simple queries whenever

[sqlite] RE: SQLite performance with mid-size databases

2004-06-16 Thread Richard Kuo
Ionut, Thank you for your input. Do you mean precompilation and then subsequent calls to the sqlite_bind API? Am definitely using transactions, and the database is entirely read-only with only the client in question accessing the db. The poor and linearly scaling performance degradation with

Re: [sqlite] SQLite performance with mid-size databases

2004-06-16 Thread Derrell . Lipman
On 2003-01-27, at 00.00, D. Richard Hipp wrote: > Enterprise scale database engines do a more sophisticated job > of selecting indices (when there is a choice like this) by > collecting lots of statistics on the indices and using complex > algorithms to make the choice. SQLite takes the easy way

Re: [sqlite] SQLite performance with mid-size databases

2004-06-16 Thread Jacob Engstrand
On 2004-06-16, at 06.04, Richard Kuo wrote: Empirically speaking, we display our data in a scrolling 2 dimensional grid format. With MS access, this grid responds instantaneously when moving through the grid. With SQLite, there is very noticable stalling and lag and the disk i/o is higher

Re: [sqlite] Locking and concurrency in SQLite version 3.0

2004-06-16 Thread Daniel K
--- Christian Smith <[EMAIL PROTECTED]> wrote: > On Wed, 16 Jun 2004, Daniel K wrote: > > >--- [EMAIL PROTECTED] wrote: > >> > >> > http://www.sqlite.org/lockingv3.html > >> > >> My thoughts are listed as they come to me. > >> > >> Thought 1: > >> > >> Section 5.0, entitled "Writing to a

[sqlite] Fw: Returned eMail: User Unknown

2004-06-16 Thread Nuno Lucas
Could the maintainer please configure the list manager to not send us this kind of messages? It is a litle boring we should have to know what old users e-mail was on the list that are invalid now. Regards, ~Nuno Lucas P.S.- I think my english is a litle bad on this phrase but I couldn't find

Re: [sqlite] Locking and concurrency in SQLite version 3.0

2004-06-16 Thread Christian Smith
On Wed, 16 Jun 2004, Daniel K wrote: >--- [EMAIL PROTECTED] wrote: >> >> > http://www.sqlite.org/lockingv3.html >> >> My thoughts are listed as they come to me. >> >> Thought 1: >> >> Section 5.0, entitled "Writing to a database file": >> After the in-memory cache initially spills to disk >>

Re: [sqlite] SQLite performance with mid-size databases

2004-06-16 Thread Nuno Lucas
This could be related with the grid handling code. In another post I already talked about the "SELECT COUNT(*) ..." performance problem, that can only be solved by tuning the code in the grid control itself. If the code is generic, it's a strong possibility it isn't optimized for this, and

[sqlite] what's the escape-character in sqlite?

2004-06-16 Thread Xuer
i want to insert text with ' and " included. such as, insert into mytable (mytext) values( ' \' hello\' ' ) , or ("\"hello\"") .both give errors. is \ not an escape-character? then what is? thanks in advance.:) - To

RE: [sqlite] Locking and concurrency

2004-06-16 Thread Wempa, Kristofer \(Kris\), ALABS
>Hi, >I am using sqlite 2.8.5 and I'd like to know if I can have a proces >that reads(select) while a proces is writing (insert or update) in the >same db. > >I have read FAQ number 7 but it doesn't help me. >Thank you very much. > >Bye Max >FAQ 7 >**Can multiple applications or multiple

Re: [sqlite] SQLite performance with mid-size databases

2004-06-16 Thread Randall Fox
On Tue, 15 Jun 2004 23:04:04 -0500, you wrote: >Hi. We are using SQLite to store and retrieve data rows where each >row is roughly 2K total in size and in a table of 15 columns. The total >size of the database ranges from 100-300 MB. > >The problem we are seeing is that query and

Re: [sqlite] Locking and concurrency in SQLite version 3.0

2004-06-16 Thread Daniel K
--- [EMAIL PROTECTED] wrote: > G'day, > > > > > > "D. Richard Hipp" <[EMAIL PROTECTED]> > 12/06/2004 08:16 AM > > > To: [EMAIL PROTECTED] > cc: > Subject:[sqlite] Locking and > concurrency in SQLite version 3.0 > > > >

Re: [sqlite] show columns headers

2004-06-16 Thread David M. Cook
On Wed, Jun 16, 2004 at 12:07:43PM +0200, bo wrote: > Hi all! > > Does anybody know if there is a switch to have sqlite writing out the > column header names with every select statement? .headers .help to see all the . commands. Dave Cook

[sqlite] Reusing SQLite's parser

2004-06-16 Thread George Ionescu
Hello SQLite users, Hello Dr. Hipp, I would like to reuse sqlite's parser to do some sql parsing against CREATE TABLE statements. However, while stepping through code from an sqlite_compile, into sqliteRunParser I cannot see the Parse structure filling appropriatelly (e.g.: trying to execute a

Re: [sqlite] Locking and concurrency in SQLite version 3.0

2004-06-16 Thread ben . carlyle
G'day, "D. Richard Hipp" <[EMAIL PROTECTED]> 12/06/2004 08:16 AM To: [EMAIL PROTECTED] cc: Subject:[sqlite] Locking and concurrency in SQLite version 3.0 > http://www.sqlite.org/lockingv3.html My thoughts are listed as they come to me. Thought 1:

[sqlite] Locking and concurrency

2004-06-16 Thread Massimiliano Zilio
Hi, I am using sqlite 2.8.5 and I'd like to know if I can have a proces that reads(select) while a proces is writing (insert or update) in the same db. I have read FAQ number 7 but it doesn't help me. Thank you very much. Bye Max * FAQ 7 **Can multiple applications or multiple instances of