Saya punya pengalaman problem dengan MyDBR. Setiap klik link atau menu yang ada di MyDBR butuh waktu 5-15 untuk loading halaman nya, mulai dari login dan apalagi saat query. Lalu saya minta bantuan team support MyDBR, dan ketemu penyebab nya yaitu masalah domain name. Berikut solusi nya:
W: I have a problem with mydbr. MyDBR working too slow in my server. every link and menu for open a page takes time 5-15 minutes. but its show correct data.
I have install it correctly.
I can login, but takes time for 5 minutes until logged in.
I can make store procedure and report, but opening every page is too slow.
Can you help me for the solution?
My server use SSL and domain name.
it is bit hard to say what might be the cause of it without access to the server. In most cases where connection to db is slow, this is due misconfigured DNS resulting slow name resolution.
What you should do is first determine if the cause of this is the web server or the datbase connection from the web server to the database server. Try to access first pages that do not require database connection. In myDBR you can for example access the ionCube loader test page mydbr/install/loader.php.
To test the database connection, you can try the script found in mydbr/tools/troubleshoot/
And i have try to acess page mydbr/tools/troubleshoot/
Connect Error (2003) Can’t connect to MySQL server on ‘172.16.125.244’ (110).
I registered mydbr with domain name.
So, what should i do?
And the problem resolved.
Thanks for your help.