Hi,

I started the conversion of a database from dbisam 4 to edb 1.03.
The db is 107Mb and after 4,5h only about 1/2 is completed!
Is this normal (P4 2.4Mhz with 1Gb RAM and plenty of free HD) ?
I was expecting a much faster migration...

--
Fernando Dias

Fernando


I also noticed that the new migration facility seemed slower. Do you have any full text indices in the tables?

Roy Lambert

Roy

No, I don't. Only normal indices.
The total time to convert that DB was 9,5 hours!
And I have some DBs bigger then this one...

--
Fernando Dias

Fernando,

<< I started the conversion of a database from dbisam 4 to edb 1.03. The db
is 107Mb and after 4,5h only about 1/2 is completed! Is this normal (P4
2.4Mhz with 1Gb RAM and plenty of free HD) ? I was expecting a much faster
migration... >>

The new migrators have to use a neutral format for the migration process, so
it uses INSERT statements to do so.  This can take some time, especially if
you have a lot of large BLOBs that need to be handled as BLOB literals (hex
strings).

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> The new migrators have to use a neutral format for the migration process, so
> it uses INSERT statements to do so.  This can take some time, especially if

I understand, but 9.5h to convert a 107Mb DB is a lot of time... I hope
you can find some way to improve this a little.

--
Fernando Dias

Fernando,

<< I understand, but 9.5h to convert a 107Mb DB is a lot of time... I hope
you can find some way to improve this a little. >>

Do you have a lot of BLOB fields in the source table ?

I will see what I can do about the performance.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Do you have a lot of BLOB fields in the source table ?

Total Database size: 107Mb
Total Nr. of tables: 35
Nr. of tables with BLOB columns : 6
Total size of ".blb" files : 10Mb

--
Fernando Dias

Fernando,

<< Total Database size: 107Mb
Total Nr. of tables: 35
Nr. of tables with BLOB columns : 6
Total size of ".blb" files : 10Mb >>

Okay, 10Mb shouldn't be a big deal.  I'll see what I can do for 1.03 B2.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

The same database that was taking 9,5 hours to convert is now taking 8
minutes, in the same computer and conditions, using version 1.04b2!
What kind of magic you made ?
Thanks.

--
Fernando Dias

Fernando,

<< The same database that was taking 9,5 hours to convert is now taking 8
minutes, in the same computer and conditions, using version 1.04b2! What
kind of magic you made ? >>

I just buffered the inserts a little using transactions.

Tim Young
Elevate Software
www.elevatesoft.com