MySQL Forums
Forum List  »  Performance

Re: millions of records
Posted by: Jay Pipes
Date: September 05, 2005 12:24PM

MySQL can handle vast amounts of data, even on a non-monster server. The speed at which a server performs is most often a correlary of how well the database schema is designed. If you are planning to use 27 VARCHAR(50) columns, with no standardization of data, no normalization, and no data type streamlining, then, yes, the performance will be horrible. But, if you spend a decent amount of time analyzing the data and selecting accurate and efficient data types for your columns, and perhaps de-NULLing fields and/or horizontally partitioning into main/detail tables, along with adding appropriate indexes on key fields, then the performance will be excellent.

The performance of the database server is a product of the amount of time spent planning and analyzing the data which will eventually compose the tables, along with a good amount of tweaking of indexes and settings once the database has been populated.

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Views
Written By
Posted
5653
September 03, 2005 12:04PM
Re: millions of records
2492
September 05, 2005 12:24PM
2296
September 26, 2005 04:30PM
2217
November 03, 2005 05:42AM
3234
November 03, 2005 06:56AM
1912
November 03, 2005 04:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.