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.
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,
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.