MyDump.BackupToFile terribly slow even with one record

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
starhu
Posts: 33
Joined: Thu 13 Aug 2009 12:13

MyDump.BackupToFile terribly slow even with one record

Post by starhu » Wed 09 Jun 2021 11:59

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!

ViktorV
Devart Team
Posts: 3047
Joined: Wed 30 Jul 2014 07:16

Re: MyDump.BackupToFile terribly slow even with one record

Post by ViktorV » Fri 18 Jun 2021 13:27

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

Post Reply