Hello everyone! First of all, wish you all a very nice healthy and successful new year!
I have come crossed this speed problem of phpMyAdmin. I searched the forum and saw nobody mentioning the similar problem, so I opened this thread to see if there would be any solution to it.
If I'm not misunderstanding, all the activities done with phpMyAdmin are going through the control panel server, right? So here's what I've experienced: My CP server is in EU, then, I have a test Webserver in EU, and 2 test Webservers in US. When I tried to use phpMyAdmin to modify a database hosted on the EU server, the speed is still ok. But when I tried to modify a database hosted on the US server, it usually take 10+ seconds to open an each page in the phpMyAdmin. It took also forever long for phpMyAdmin to export a sql dump of lower than 1MB to download. I also tested the db export function within Enhance panel for the same server and same database, the speed was still acceptable.
I also did another test completely new, from a CP server in US and Webservers in US and EU. This problem stay the same.
So, I'm not sure if this is indeed some kind of bugs or if it's just like that with phpMyAdmin. However, when I was using other web hosting services in the past, I never had this kind of speed problems with their phpMyAdmin. Is there maybe the possibility that every user can use phpMyAdmin directly from the server which their websites are on?