MyDump too slow

ben · Post by **ben** » Thu 12 Apr 2007 20:47

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

Antaeus · Post by **Antaeus** » Fri 13 Apr 2007 07:52

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.

ben · Post by **ben** » Fri 13 Apr 2007 14:12

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

Jackson · Post by **Jackson** » Mon 16 Apr 2007 15:06

Thank you for information.
The investigation of the problem is in progress.

Jackson · Post by **Jackson** » Wed 18 Apr 2007 06:55

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.