Devart Forums

Hello,

I noticed that MyDump.BackupToFile terribly slow even with one record.
I found out that each time I call MyDump.BackupToFile, in change BackupToFile calls "SHOW TABLE STATUS" which , at a complex database is more than 1 minute!

This means even if I want to save 1 record, the program freezes for more than 1 minute!

I use MyDac 10.4.3 and these settings:

MyDump := TMyDump.Create(nil);
MyDump.Connection := MyForm.Connection;
MyDump.Objects := [doData];
MyDump.BackupToFile(MyFileName,'select * from temp_invoice;') ;

Thank you for your reply!

Hi Henry,

Thanks for your reply.
Please be informed that while working TMyDump executes system queries to MySQL server in order to receive required information and one of them is SHOW TABLE STATUS.
Kindly note that we will review the option of query modification for MySQL higher than version 5.

Regards,
Viktor