Đã Hủy

WordPress SQL performance problem

I have a new WordPress installation which I installed as a development environment. We had WP e-commerce installed with an incomplete store with about 450 products. But I decided not to use WP e-commerce and uninstalled it, and deleted all of the posts and pages that were associated with that store.

Now the WP installation is pretty basic and with a small number of posts and almost no pages. But the performance on the c/panel (backend) is extremely slow and on the front end is slow.

I believe that there are probably remains of clutter in the SQL database, or a poorly designed SQL DB, left over from the WP e-commerce store installation.

Project is to solve the performance problem either by cleaning up the SQL database or fixing the SQL database or re-installing WP with a clean installation so I can re-upload what little content there is and start all over again.

One complication is that there are multiple SQL databases on the server and a live/production website (Prostores sopping cart) on the root directory of the domain, and you must not disturb that SQL database. Our hosting company insisted upon doing the WP installation the first time, because they said that if the placement and configuration of the SQL database was not done correctly, it would interfere with the SQL database of the production website in the root directory: So you must be very careful about that and not change the position/location/basic configuration of the SQL server:

I think the best solution is to re-install WP using the exact same position/location/basic configuration of the SQL server.

Kỹ năng: MySQL, SQL, WordPress

Xem thêm: placement new, problem fixing, panel configuration, new wordpress website development, fixing problem, commerce website production, location sql database, wordpress development company, wordpress slow, wordpress server configuration, wordpress performance, wordpress installing, wordpress installation, sql server development, sql database website, sql 2012, solve problem, installing wordpress, directory wordpress, database performance , clutter, wordpress website backend development, cart server performance, wordpress server slow, sql server front

Về Bên Thuê:
( 164 nhận xét ) Tucson, United States

Mã Dự Án: #1727469