On one of the sites of my multi-site network; I'm creating a custom post type 'Events'. Each of the 'Events' post will have about 30-50 custom post fields - because we require event creators to enter lot of event related data.
I noticed that WP creates multiple rows to store custom post fields; and that means each of our 'Events' post will have ~100 (or maybe more?) number of rows inserted into the database.
Now, we expect to create large number of these 'Events' posts; all filled up via front-end by our users. I'm talking about tens of thousands of user created events, each with lot of custom fields data.
I thought a better plan would be to encode all the custom fields data as JSON string and store it in the database as just one custom field; thus creating only one entry per event in the database.
So far so good.
The problem: I'm wondering what would happen when we have large number of events, and we have to search them based upon custom post fields. Will it be efficient to search inside jSON strings (text) or just run through large number of rows.
Waiting for your responses, thanks!