242492 MySQL Database Optimization

I have a MySQL database that is very slow. I would like to have this database optimized. I'm looking for someone that is an expert is working with large MySQL databases. The search query seems to work and does produce valid results but can take one or two minutes and I need it to work in just a few seconds. At one time it worked well but then when some records were removed that were older records it slowed a great deal. If you are interested please leave me a message on the project message board asking for access and telling me of your experience and qualifications to work on such a project and I will provide access for you to view the site. The site is not currently live but I will send you a URL to view the admin area and run test and other access as needed. Thank you for your consideration.