WampServer
Apache, PHP, MySQL
on Windows
Very slow when accessing a larger database
Posted by:
fullstackdev
(---.ded.execulink.com)
Date: October 12, 2023 04:04PM
I am running Windows 10 (64 bit) & Wamp 3.3.1 (64 bit), MySql 8.0.21, php 8.1.8, Apache 2.4.48
If I navigate to a smaller database using the sidebar menu, it's very quick. However, when I try to navigate to one of my larger databases (~2.5G
, it takes over 1 minute for it to load the schema and display the tables. Is there any troubleshooting that can be done to try and speed this up? I routinely need to switch between 5 or 6 databases this size, and the delay is a bit of a nuisance.
Edited 1 time(s). Last edit at 10/12/2023 04:06PM by fullstackdev.
If I navigate to a smaller database using the sidebar menu, it's very quick. However, when I try to navigate to one of my larger databases (~2.5G
, it takes over 1 minute for it to load the schema and display the tables. Is there any troubleshooting that can be done to try and speed this up? I routinely need to switch between 5 or 6 databases this size, and the delay is a bit of a nuisance.Edited 1 time(s). Last edit at 10/12/2023 04:06PM by fullstackdev.
Re: Very slow when accessing a larger database
Posted by:
Otomatic
(Moderator)
Date: October 12, 2023 04:14PM
> to load the schema and display the tables
If you're using PhpMyAdmin, please refer to the PhpMyAdmin documentation.
If you're using another application, please refer to the documentation for that application.
See MySQL documentation for parameters to be applied for large databases.
---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
If you're using PhpMyAdmin, please refer to the PhpMyAdmin documentation.
If you're using another application, please refer to the documentation for that application.
See MySQL documentation for parameters to be applied for large databases.
---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
Sorry, only registered users may post in this forum.
