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 WP 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 meta data 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 meta data 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_posts and 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 wp_postmeta table.
1) One possibility we've discussed is only holding "active" Tours in the wp_posts and archiving older Tours to a separate table. Is anyone aware of any plugins that do anything like this?
2) Another possibility is putting the Tours into the wp_posts table, 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?
3) Any other suggestions of how we might best implement this much data into Wordpress?