execution time question

John Luetich

Delphi Developer

execution time question

2005-12-14 01:04:35 AM
delphi230
Hi
I'm converting my Delphi 6 app with paradox/bde to access/ado.
There are 30-odd tables in a mdb that is about 180 mb.
The execution time of the app is much longer than using paradox/bde. Is
this normal?
Thanks
John

Olivier Beltrami

Delphi Developer

2005-12-14 02:08:47 PM

Re:execution time question

Quote

BDE had quite a few problems but being slow was never one of them.
I know ... everytime I do some testing with other desktop solutions, to get

rid of Paradox, I am horrified at the loss of speed when abandonning
Paradox.
Olivier

John Luetich

Delphi Developer

2005-12-14 10:34:41 PM

Re:execution time question

Would you continue with the conversion or should I wait until BDE is totally
obsolete?
"Brian Bushay TeamB" <XXXX@XXXXX.COM>writes

Quote

>I'm converting my Delphi 6 app with paradox/bde to access/ado.
>There are 30-odd tables in a mdb that is about 180 mb.
>The execution time of the app is much longer than using paradox/bde. Is
>this normal?

That depends on how your application is designed. BDE had quite a few
problems
but begin slow was never one of them.
If you are opening a dataset with a lot of records ADO will probably be
slower.
There are some things you can do
With ADO dataset components you should disableControls before opening a
dataset
that returns many records.
For Access the fastest way to work with the data is to use command type
TableDirect.
If you give us more information on what is going on in your application
when you
experience a difference in speed you my get other suggestions.

--
Brian Bushay (TeamB)
XXXX@XXXXX.COM

Olivier Beltrami

Delphi Developer

2005-12-15 01:18:41 AM

Re:execution time question

Quote

Would you continue with the conversion or should I wait until BDE is
totally obsolete?
I would _not_ leave Paradox for Access. The BDE may not be developped

anymore, but to me that also means that there are no new bugs ;-) The apps I
have converted from paradox were converted to DbiSAM which allows for an
almost trivial initial conversion of your tables AND your source code, and
yet can eventually be changed with almost no work into a C/S solution. But
don't go to Access, you will regret it.
Olivier

Bill Todd

Delphi Developer

2005-12-15 02:19:07 AM

Re:execution time question

Out of curiosity, why are you moving from one deprecated technology to
another. The Jet database engine has been deprecated almost as long as
the BDE and ADO is no longer being developed or maintained. It would
seem to make more sense to move to Advantage, NexusDb, DBISAM or some
database that is still being developed and appears to have a future.
--
Bill Todd (TeamB)