> > To be honest, the vast majority of database installations experience > > problems in performance caused by poor query and schema design, > > bad application logic or grossly underspecified hardware. A change in > > the number of files used to store the data is extremely unlikely > > to resolve these problems given all other variables in the environment > > remain fixed. > > > > What does everyone else think? > > I fully agree with the part about performance and the number of > files. :-)
High-end database systems perfer more files, as they can be spread across multiple (usually fast SCSI) disks. Most databases recommend logs be kept on seperate disks than database files. Changes in the number of files can resolve problems if the problems are the result of low disk IO and you have money to throw at the problem. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]