Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 10 total |
DBISAM migration |
Fri, Jun 1 2007 6:05 PM | Permanent Link |
Fernando Dias Team Elevate | 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 |
Sat, Jun 2 2007 7:04 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Fernando
I also noticed that the new migration facility seemed slower. Do you have any full text indices in the tables? Roy Lambert |
Sat, Jun 2 2007 11:37 AM | Permanent Link |
Fernando Dias Team Elevate | 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 |
Mon, Jun 4 2007 3:15 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Mon, Jun 4 2007 7:40 PM | Permanent Link |
Fernando Dias Team Elevate | 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 |
Mon, Jun 4 2007 10:06 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Jun 5 2007 5:29 AM | Permanent Link |
Fernando Dias Team Elevate | 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 |
Tue, Jun 5 2007 1:33 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Jun 13 2007 8:36 PM | Permanent Link |
Fernando Dias Team Elevate | 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 |
Fri, Jun 15 2007 7:58 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |