Hello, My name is Leonardo and I represent Medina Technologies, a web company focused in design and web development, located in Rio de Janeiro, Brazil.
For your project, we can either use another solution like Sphinx to store data and optmize searches and indexing, or make some changes to MySQL queries like delayed insert, and by creating some indices in the mysql tables. Please let me know your thoughts.
I have read all the requirements of this project and my team can provide high quality professional results at a low cost. Please contact us for more details.
Our team consists of 10 programmers/designers with over 5 years’ experience and a vast area of expertise (XHTML, CSS, PHP, JavaScript, MySQL, ASP, Logo design, banner design and much more, including CMS like WordPress, OpenCart, Drupal, Magento etc). Please check our profile, for more info.
We can do this for you. I am looking forward to work on this project!
Regards, Leo.