Hi sir,
My name is Leonardo Medina, and I´m from Brazil.
I have lots of experience in PHP & MySQL.
For your project, at first I will have to create some indices for your database tables as well as optimizing all db queries. Also, depending on your kind of searches, if you need a full-text search for example, we will need to implement a new db system like Sphinx or Solr/Lucene, for which I can get a response time below 1 second even in a database with millions of rows.
Please drop me a line, so we can discuss this project in details and I can make a proper bid.
I'm an experienced Web Developer / Software Developer working since 1996 in this field, with 5+ years experience in PHP, ASP, HTML, CSS and Javascript (JQuery & Ajax), 8 years in Delphi and 1 year in Java, 2 years of experience in programming stored procedures, triggers, creating tables and relationships for SQL Server, and 10 years in mySQL; 2 year in Solr/Lucene (for full-text searches), Redis and CouchDB.
Since 2007, I am responsible for the web development/design and server configuration of the brazilian news search engine "Hoje Noticias", developed in PHP, mySQL, XML, Smarty (a template engine for PHP) and Solr/Lucene for full-text searches. It has a crawler (HnBot) who crawls news every hour from several web sources, and makes use of XPATH and Regular Expressions to extract title, descriptions, date, etc. from the news.
Looking forward to hear back from you.
Best Regards