Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Will export 20GB database cause a loss of application speed?

1 posts
Sven's profile image Sven posted 5 days ago in General Permalink

Hi Ansgar, we have to make a backup of our 20GB database. Will the export function in HeidiSQL cause a loss of application speed while creating the backup? Do you know how long it will take with attached settings? Thanks in advance.

1 attachment(s):
  • HeidiSQL
8841 posts
ansgar's profile image ansgar posted 5 days ago Permalink

You mean, the application may get slower after the export? Or during the export?

I'm just exporting three databases here as a test, summing up to roughly 20 GB, like yours. I see the export gets unnecessarily slow on certain tables, likely due to too large chunk processing. Apart from that, I have no issues.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.