Hello Folks,
I’d like your ideas on a concept I’m working on for a project. I’m developing a CI based site that’ll sell entertainment products i.e audio, video, comedy, ringtones etc. I want to add a comprehensive search application and I’m a bit confused on what method to use.
This is it
Note: Each product type has its own db table and each record will have a ‘tags’ column to store words that describes the item in that row(for easy searching)
A. Will the search be faster if I create a special table for search with only two columns: ‘item id’ and ‘tags’ where all the products sold on the website will be. This is where i’ll run searches and then with the item_id call up more information from the specific products table.
OR
B. Do I just use the tags in the tables created for each product to run searches.
Please If u suggest option A, how do i work-around the limits in number of rows in mysql db.
Thanks in advance!