om.au> Subject: [sqlite] Speeding up
your SQLite DB (Windows mostly)
02/09/2005 07:18
> standard VCL stuff so there's a little overhead. But surely not as dramatic as
> suggested. But there's one condition. Use transactions! Without them, you'll
> never get a good performance.
Perhaps not dramatic no, but I was getting to the point where I am
setting DB page sizes to match OS Clu
Quoting Chris Schirlinger <[EMAIL PROTECTED]>:
> > I wouldn't sell the BDE-style components short, as they may be useful
> > for some, if well-written and well-documented, but I like simple.
The (Borland) BDE is a lot of overhead conceirning database access, but it's a
transparent layer allowing
> I wouldn't sell the BDE-style components short, as they may be useful
> for some, if well-written and well-documented, but I like simple.
Oh quite true, but in my case (and really what I was trying to get at
in that monotribe) was to get the speediest database access, you'd be
better server l
>>From what I experienced, the exported functions from the DLL were
>simple to use and did everything you wanted, though perhaps slightly
>differently from the Delphi DBE way some people may be used to
I wouldn't sell the BDE-style components short, as they may be useful
for some, if well-writ
> Make a wiki page.
Not a bad idea :) Done
Make a wiki page.
On Thu, 10 Feb 2005 11:18:39 +1100, Chris Schirlinger
<[EMAIL PROTECTED]> wrote:
> I've been posting a lot on speed and SQLite, just thought I'd dump
> the results and findings into one message including a nice example on
> how dumb you can get in the hopes no one else falls thi
No, thank you for taking the time and effort for this very informative
post-mortem. There's some stuff here I didn't know, so my knowledge and
skills have also been expanded.
Regards.
rayB
*** Confidentiality and Privilege Notice ***
This e-mail is intended on
I've been posting a lot on speed and SQLite, just thought I'd dump
the results and findings into one message including a nice example on
how dumb you can get in the hopes no one else falls this low :)
After several weeks of playing with SQlite3 we have finally gotton
what we want out of a DB. F
9 matches
Mail list logo