January 20, 2009
Is searching a large MySQL database going to be a problem?
Robin P asked:
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.
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.
Filed under Programming & Design by administrator
Comments on Is searching a large MySQL database going to be a problem?
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.