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.

Taidot: MySQL, SQL, WordPress

Näytä lisää: what is placement new, problem fixing, panel configuration, new wordpress website development, fixing problem, e commerce website production, location sql database, wordpress development company, wordpress slow, wordpress server configuration, WordPress performance, wordpress installing, wordpress installation, wordpress configuration, 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

Tietoa työnantajasta:
( 169 arvostelua ) Tucson, United States

Projektin tunnus: #1727469