BorlandTalk.com

Normand · Guest

I am doing some speed tests to see whether MS Access could be used on some
Delphi projects.

I found that a simple loop through a MS Access table (with an ADO
connection) takes a lot of time when compared to a similar operation on
another format (such as dbase or Advantage). Simply doing the following
loop:

Repeat
AdoTable1.Next;
Until AdoTable1.Eof;

Takes several minutes to run while a similar operation on Advantage takes no
time (maybe only a few milliseconds).

Is this something specific to MS Access or the connexion I am using? Is
there a way to obtain faster access to MS Access data files?

Normand

Bill Todd (TeamB) · Guest

Things to think about before you choose Access:

Microsoft has deprecated the Jet engine and, thus, the Access
database.

Access does not scale. I have see a _few_ cases where performance was
adequate with 12-15 users but it usually gets bad in the 5-10 user
range.

Access is a file server database. Client/server is much more reliable
and should be used for _all_ multiuser applications.

Like all file server databases, Access is vulnerable to corruption any
time a client PC crashes. Since Access stores the entire database in
one file you will lose everything if the file cannot be repaired.

As you have seen, Access is not very fast for some operations.

Personally, I would not use Access for anything.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)