I currently have a webside called storelocator.no.
Here you can search for a brand, and you can see what stores sells this brand.
Clicking a store, you will see what brands this store has.
Currently I am using custom database for this.
But now that WP has custom post types, I'm considering if I should create a custom post type for a store and one custom post type for a brand.
I still have to make the connection between store and brand -> A store can have many brands, a brand can be in many stores.
I also have to connect certain users up to a store or brand (store owner or brand owner), så that they can maintain infromation.
Normal users can also sign up, so that they can add extra stores / labels into the system.
Currently I have over 7.000 brands registered, and I will in due time have mane stores in the system.
My questions is this:
Should I stick to custom tables? Or should I take advantage of WP Custom post types? Would the site be slower using custom post types if I have several thousands entries?
Oh, another thing. A user is never backend in WP to register data., Everything is done from front end.