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!
MyDump.BackupToFile terribly slow even with one record
Re: MyDump.BackupToFile terribly slow even with one record
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
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