Re: Simple, free RDBMS for VB3/6 with minimal installation footprint

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks, will read that chapter as well.
OK, trying this one now: SqliteDb.dll
from: http://www.etib.com.ar/Package.zip
and it seems to work well.

Any idea how you create a SQLite .db file in VB?

RBS

"MM" <kylix_is@xxxxxxxxxxx> wrote in message news:h4vbl2lvroqimf7ighrttkjp05j7utog22@xxxxxxxxxx
On Sat, 11 Nov 2006 15:20:10 -0000, "RB Smissaert"
<bartsmissaert@xxxxxxxxxxxxxxxx> wrote:

Isn't the free version from terrainformatica disabled in some way?

It has none of the bells and whistles of the paid-for versions, true,
but the basics work, and for a simple solution they're all I would
need.

Slower?

I don't know whether the free version is slower than the paid-for
versions, but it is definitely noticeably slower than Access 2.0 in
certain cases, for example:

My app depends heavily on using the LIKE keyword with one or more
wildcards. Depending on the number of rows returned, Sqlite is a lot
slower than Access 2.0, even despite the fact that I am using an
Access 2.0 mdb via Visual Basic 3! Whereas in Sqlite a typical query
with wildcards might take 3 seconds, in Access 2.0/VB3 it's hardly
measurable it's that quick.

For queries that make less use of wildcards or for queries that return
a low number of rows, there is no difference in performance between
Sqlite and Access 2.0/VB3.

I am now investigating what the position is with indexes in Sqlite.

I am also reading the free sample chapter of "The Definitive Guide to
SQLite" from
http://www.apress.com/book/supplementDownload.html?bID=10130&sID=3520
which is an interesting read.

MM

.

Relevant Pages

  • Re: Simple, free RDBMS for VB3/6 with minimal installation footprint
    ... It has none of the bells and whistles of the paid-for versions, true, ... but the basics work, and for a simple solution they're all I would ... Depending on the number of rows returned, Sqlite is a lot ... with wildcards might take 3 seconds, ...
    (microsoft.public.vb.general.discussion)
  • Re: Why the difference in these 2 SQLite files?
    ... I have a large SQLite db file, which I make on a work PC ... I now make a trivial change ... I then run the same queries again and they are a lot faster, ... with the low level file properties ...
    (microsoft.public.vb.general.discussion)
  • Why the difference in these 2 SQLite files?
    ... I have a large SQLite db file, which I make on a work PC with VBA/VB6. ... I then run the same queries again and they are a lot faster, ... Apart from that trivial change the files are otherwise exactly the same and the SQLite query plans for both queries are the same. ... As this problem somehow seems to have to do with the low level file properties ...
    (microsoft.public.vb.general.discussion)
  • Re: Why the difference in these 2 SQLite files?
    ... I have a large SQLite db file, which I make on a work PC ... I now make a trivial change ... I then run the same queries again and they are a lot faster, ... with the low level file properties ...
    (microsoft.public.vb.general.discussion)
  • Re: [PHP] SQLITE
    ... SQLite uses the filesystem for storage. ... SQLite is going to serialize those queries to help you avoid ... Chris Shiflett - http://shiflett.org/ ... PHP Security Handbook ...
    (php.general)