Page 1 of 1

MyDump too slow

Posted: Thu 12 Apr 2007 20:47
by ben
Hello,

Im trying to backup a 30.000 records table with MyDAC 5.0 and MySQL 5.0.27

it looks like that TMydump is very slow compared to mydump.exe or Navicat Dump to SQL.

TMyDump wants 10 minutes while Mydump.exe (native of mysql) or Navicat want 2-4 seconds.

Thanks

Posted: Fri 13 Apr 2007 07:52
by Antaeus
Please specify which method do you use to save data with TMyDump: Backup or BackupToFile? The first method is slower because the generated text is loaded into StringList.

Posted: Fri 13 Apr 2007 14:12
by ben
first I tried Backup and it was slow.
Then I switched to BackupToFile and it was also unacceptable slow.

Then I turned to WinExec('MySQLDump.exe'... and I hope CoreLab will address this issue soon

Thanks

Posted: Mon 16 Apr 2007 15:06
by Jackson
Thank you for information.
The investigation of the problem is in progress.

Posted: Wed 18 Apr 2007 06:55
by Jackson
Thank you for information.
We have reproduced the problem and fixed it.
This fix will be included in the next build of MyDAC 5.
Please watch for announcements at the forum.