Custom post type table

Question

I am creating a web application and I am using Wordpress as the back-end to take care of the database. Wordpress has all the functions I require. This is not related to blogging or posting posts.

Does anyone know of any solution to create a custom table per custom post type?

This is important. The post types will be storing very large documents and objects, usually word, xml and php objects. There will be lots of entries since the app will be used by hundreds of users so I want to keep it separate. I want other features like post meta, tags and taxonomies to be available as well.

I will keep it short. I have searched Google for a solution but developers seem to provide different workarounds. Can't I hook/filter wordpress with a plugin so that each time a custom post type is actived/queried a different table name is used. I am sure this is possible.

Answer 1

I am not 100%, or even 83%, sure what you are asking. The project seems complex and a lot a specifics are missing from the question. However,

1. I am fairly sure that you don't need to duplicate the entire post table or post type set of tables.
2. I am also not even sure if you need a custom table at all. The postmeta table performs very well depending on the query.
3. If you do end up needing a custom table, just create a table to hold the particular "Extra" bits of information that you need and merge that information into your queries where necessary.

If you try to do what I think you are thinking about doing, you are going to be hooking into many, many hooks-- dozens maybe. It is going to be complicated and difficult to maintain.

Without more information, that is all I've got.