Is searching a large MySQL database going to be a problem?

December 14, 2010 – 9:00 pm

I just started exploring MySQL for a database that I want to set up. I want the online user to be able to search for any word in the entire database. The database might become 500 meg over time (small compared to facebook, big compared to a employee databse). At what point does searching that amount of a MySQL database going to be an issue? I am new to MySQL and databases, so any other help or suggestion regarding this topic is greatly appreciated.

Related posts:

  1. How to import a large list into MySQL database?
  2. How do I access a MySQL database on another drive?
  3. What is a good application for designing a MySQL-driven website on Mac OS X?
  4. If i have a mysql database of places with GPS cords, How could i find the places with in 10 miles?
  5. How do i build a interface to WRITE to my mysql database?
  6. What is the best approach to delete garbage and expired entries in a MySQL database?
  7. How to connect my simple website to a mysql database?
  8. How do i connect a windows C# application to a remote Mysql database?
  9. how to store images with links in mysql database and how to display it on the web page?
  10. How do I create a MYSQL database in Dreamweaver CS4?
  1. One Response to “Is searching a large MySQL database going to be a problem?”

  2. Hi Robin, I work for a company that runs a mysql database that’s about 2.5GB in size. We have a few tables that have 10 million plus records. In general we have found that searches are very fast as long as the fields that we are searching on are indexed properly. I’ve worked with a number of other RDBMS’s including Oracle and MS SQL Server and in my opinion, mysql is very competitive across the board with the others and in many ways easier to manage, especially now with support for stored procedures in version 5. Hope this helps.

    By mti2935 on Dec 14, 2010

Sorry, comments for this entry are closed at this time.