DAC 1.09b4

I have a customer that upgraded from software running DBISAM 3 to EDB
1. They wrote an app using the ODBC driver. They are saying the new
driver is taking almost 4 times as long as the old DBISAM driver. Is
this a known problem fixed in v2?

Michael Fullerton escreveu:
> DAC 1.09b4
>
> I have a customer that upgraded from software running DBISAM 3 to EDB
> 1. They wrote an app using the ODBC driver. They are saying the new
> driver is taking almost 4 times as long as the old DBISAM driver. Is
> this a known problem fixed in v2?

Not knowing how is the driver used, it's difficult to say.
Almost four times slower doing what?

--
Fernando Dias
[Team Elevate]

Michael,

Same question as Fernando - what are they executing ?

--
Tim Young
Elevate Software
www.elevatesoft.com

On Mon, 15 Jun 2009 13:18:03 -0400, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote:

>Michael,
>
>Same question as Fernando - what are they executing ?

Basically they are reading EDB records and transferring some of the
fields to a MS SQL database. On one system they had 54,000 recs. On
DBISAM it took 3-4 secs. After the upgrade it took 5-10 minutes. On
trimming down to 37,000 rec it takes 7-8 secs.

Michael,

<< Basically they are reading EDB records and transferring some of the
fields to a MS SQL database. On one system they had 54,000 recs. On DBISAM
it took 3-4 secs. After the upgrade it took 5-10 minutes. On trimming down
to 37,000 rec it takes 7-8 secs. >>

That really doesn't make much sense unless one or more of the rows
eliminated has one or more very large BLOB columns.  If you want to send me
the database catalog and table files, I'll be happy to take a look.

--
Tim Young
Elevate Software
www.elevatesoft.com