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
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
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
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
--- 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
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
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
>>
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
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
>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
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
--- [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
>
>
> >
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
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
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:
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
16 matches
Mail list logo