Hello,
I manage a large Joomla website that consists of approximately 15GB of files and a 5GB database. Within the database, the largest table contains over 30 million records, and there are several other tables with over 1 million records.
I’ve set up a command-line ZIP backup using Akeeba Backup with an upload to Google Drive. While I managed to configure it successfully, the backup process (excluding the upload) takes over 1.5 hours to generate the file.
To improve performance, I increased the "Number of rows per batch" to 100,000, which reduced the time, but I am unsure if there are additional settings or best practices that I can apply to further optimize the process.
Since this is a CLI-only setup for a late night backup, timeouts, I/O limits and memory limits are not major concerns.
Thank you for your help!
Best regards,