[mailto:[EMAIL PROTECTED]
Sent: 07 September 2007 02:46 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQLite or MS Access
On 9/7/07, Andre du Plessis <[EMAIL PROTECTED]> wrote:
[..]
> What I don't understand is how Access, and other DB's are able to
still
> operate much f
On 9/7/07, Andre du Plessis <[EMAIL PROTECTED]> wrote:
[..]
> What I don't understand is how Access, and other DB's are able to still
> operate much faster (maybe not as fast), and still flush file buffers to
> disk, is beyond me. Maybe it really still caches it, I would not be
> surprised if you
sis [mailto:[EMAIL PROTECTED]
> Envoyé : vendredi 7 septembre 2007 10:25
> À : sqlite-users@sqlite.org
> Objet : RE: [sqlite] SQLite or MS Access
>
> Well here are my test results (im using Delphi for this one)
>
> This is my insert statement:
>
> INSERT INTO TEST (TEST_ID
The problem was transactions
Thanks all
-Message d'origine-
De : Andre du Plessis [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 7 septembre 2007 10:25
À : sqlite-users@sqlite.org
Objet : RE: [sqlite] SQLite or MS Access
Well here are my test results (im using Delphi for this one
Well here are my test results (im using Delphi for this one)
This is my insert statement:
INSERT INTO TEST (TEST_ID_NO_IDX, NO_INDEX, TEST_DATA, TEST_ID) values
(%d, %s, %s, %d)
This table deliberately has NO index.
1000 inserts took:
Inserting MS Access - 4,043.273 ms
Inserting SQLite -
have you try this on usb key ? i've very bad benchmark on this, try in
hard disk in this case
Sylko Zschiedrich a écrit :
Do all insert's in one transaction and it will be done in 1 second or less.
Begin transaction
1..1000 insert into table
Commit transaction
Ciao
Sylko
I wrote a little server based on SQLite, and it works just fine. I
handled the "multiple processes" issue by simply having the software
make a list of requests, then handling those requests serially.
Essentially there are two parts to the software. One listens for
requests and lists them. It
On Wed, 6 Sep 2006 18:05:36 +0100, you wrote:
Hello Mark
I think, either Access or ODBC is not a real good idea.
SQLite is a real good idea, if you need a small embedded database.
So far as I know, its even not a good idea, to compare MySQL and
Postgres to SQLite, because MySQL is a
> -Original Message-
> From: Allan, Mark [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 06, 2006 10:06 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite vs MS Access
>
> Hi,
>
> After successfully using SQLite on an embedded device, we are
> now thinking of using
On 9/6/06, Allan, Mark <[EMAIL PROTECTED]> wrote:
Hi,
This would be used in place of an MS Access database on a local/network disk. I
believe that SQLite should be quicker for both transactions and queries than
Access. The one draw
I've repeatedly seen database corruption with Access in
Sqlite is far more portable than Access. There is also an ODBC
interface available so that you can use the standard SQL/CLI API.
Just be wary of the fact that Sqlite does not have a server like
PostgreSQL so you may run into some locking situations if you have your
database distributed
Hi Mark:
We briefly considered using JET (the Microsoft database engine for Access), but
went with SQLite in the end for a few reasons:
1. portability was important to us
2. open source with lots of applications (seems very well supported)
3. it seems to handle large databases very well
One of
Mark,
If you looking for accessibility to your SQLITE DB from within other windows
applications (That support ODBC) then there is an ODBC driver for SQLITE
which is probably the most common manner to access databases.
Take a look at the following link.
What level of access is needed from outside of the application? There are
nice GUIs available for SQLite that people could use. There is in theory
ODBC access as well, although my experience with ODBC and SQlite was not
especially happy.
Clay
Allan, Mark said:
> Hi,
>
> After successfully
On 9/6/06, Allan, Mark <[EMAIL PROTECTED]> wrote:
Hi,
After successfully using SQLite on an embedded device, we are now thinking of
using SQLite in a PC application.
This would be used in place of an MS Access database on a local/network disk. I
believe that SQLite should be quicker for both
15 matches
Mail list logo