I have a custom CMS, that we're looking to port over into Wordpress. (I can see you asking yourself:
Why not just stick with the custom CMS?
Well, it's outdated, clunky, and getting to be too much of a hassle to maintain; there are also many features of WordPress that we would really like to take advantage of.
So here's the issue -- We have a main type of content (let's call them Tours). Each Tour has about 30 pieces of metadata associated with it (all currently different columns on the
Tours table). We currently have about 600,000 Tours.
Each Tour has several different types of images associated to it, from Interior Images, to Exterior, to Floor Plans, etc. Each Image has about 10 pieces of metadata associated with it (again, all currently columns on the
Images table). We currently have about 7 million Images in our system.
You can likely see our problem -- if we put all Tours and Images into the default
wp_postmeta table, we're going to end up with millions of rows in
wp_posts, and far more than that in the
wp_postmeta table. I'm not sure how much mySQL can handle as far as numbers of rows, but it seems likely that we will reach a slowdown point, especially when querying the
One possibility we've discussed is only holding "active" Tours in the
wp_postsand archiving older Tours to a separate table. Is anyone aware of any plugins that do anything like this?
Another possibility is putting the Tours into the
wp_poststable, and keeping the Images separate from that. One thing we would really like to use, though, is the Wordpress image uploader. Is there anyway to override where the image data is saved?
Any other suggestions of how we might best implement this much data into Wordpress?