optimize for wordpress mysql database

CLOSED
Bids
16
Avg Bid (USD)
$177
Project Budget (USD)
$30 - $150

Project Description:
dear, i have a website build in wordpress, its work great, but i import a lot of database so its get very slowly
have over 500,000 records in sql database table "post_metag" or something like that.
i want import alot more, about 2mil records, but its can't handle any more.

please optimize my sql for me, i think i have to rewrite database table or ...what ever
i tried
1. install wp super cache, wp db cache,
2.disabled all plugin
3. run optimize mysql on server.

but just a little better.

and i have to remove some database for get faster

please bid if you read becareful and know what i did. so you dont have to do that again.
please bid if you have the good solutions should be fixed this problem.
payment just release after done the job.
no milestone

thanks, and im looking for good php,mysql also. for work longterm.

Skills required:
CSS, Linux, MySQL, PHP, Wordpress
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 150
in 1 days
$ 150
in 1 days
$ 150
in 0 days
$ 100
in 2 days
$ 50
in 1 days
$ 40
in 2 days
$ 30
in 2 days
$ 60
in 2 days
$ 80
in 1 days
$ 100
in 5 days