Huge database

I am surprised you have anything other than posts and attachments in that table.
The importer does put a lot into wp_post_meta which can be cleared down if you don’t need to do any other imports.
I don’t know what post_type = http is, do you have other plugins installed?