We need a Web Developer with mySQL knowledge to configure our adult personals website. [url removed, login to view]
We are using the following:
Sweet Date Theme(ThemeForest) Powered by Buddy Press
We had 2,000,000 profiles installed by a third party which resulted in extremely slow performance.
Below is the advise from our Server support:
Your word-press media library is loading very slow due to problems with the database used for your wordpress installation. Your site databases size is 16GB. You need to check that with your site developer as its an issue with database itself and not something with the server.
You will need to optimize your database queries from your web developer. I checked this and when you try search any profile on your site, your databases queries are taking so long time to search that in databases and due to that you are getting this issues. I will suggest you please contact your web developer and ask them to check this. You may also want to check with a mySQL developer.
| 21 | maxxxper_wp58 | localhost | maxxxper_wp58 | Query | 103 | Copying to tmp table | SELECT DISTINCT wp_bp_xprofile_data.user_
id FROM wp_bp_xprofile_data JOIN wp_usermeta um ON um.user_ |
| 43 | root | localhost | | Query | 0 | | show processlist
root@sh39 [/home/maxxxpersonals/www]# du -sch /var/lib/mysql/maxxxper_wp58/
Please give us an estimate and time frame.
7 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
hi your issue is related to the heavy data without indeximg. your data cn be indexed ad will result in better [login to view URL] lrt me know if you are interested I can do it for you.