Hey guys, I need a script that has only 2 subpages: - show search / tag results with custom pagination - product page There will be millions of rows of products leading to tens of millions of tags so what I need is an efficient DB design that handles extensive tagging. A Row example: "Osama bin Laden shot dead in Pakistan" | Date | SomeOtherTextInformatioNotIncludedInTags I need to refine all possible tags from this: "Osama" "Osama bin" "Osama Laden" "Osama shot" ... ... ... "Osama dead" ... The script has to be really fast with low CPU consumption operating over millions of products and tens of millions of tags (maybe more later on?) so you have to make sure that the data is somehow divided into several tables that there are not millions of rows in one table etc. A site example would be torrentz.eu (http://torrentz.eu/search - a search page based on tags), (http://torrentz.eu/87171cac4b10b28e8ceb00df18a883bbf3363fca - a product page with tags) I will ask you to implement this into a free theme for the time being so some very basic html is needed but just for the proof of a concept. I can't provide you the data atm so you have to either work without any realtime date or create your own. Please write me your price estimates and previous experience if you find it relevant. Thanks, old
Answer to a question: no fulltext If someone enters Osma, the engine will search only through KW and see that there is nothing with that name. No %Osma% search. ------- One more thing: it should be efficient to add new tags every minute