List:General Discussion« Previous MessageNext Message »
From:David Griffiths Date:December 16 2003 4:36pm
Subject:Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?
View as plain text  
> > 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
Thread
MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Jerry Apfelbaum14 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Sven Köhler15 Dec
    • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan15 Dec
      • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Sven Köhler15 Dec
        • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan15 Dec
          • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Tobias Asplund15 Dec
            • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan15 Dec
      • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Jeremy Zawodny16 Dec
    • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?David Garamond16 Dec
      • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Jeremy Zawodny16 Dec
        • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan16 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Martijn Tonies15 Dec
    • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Sven Köhler15 Dec
      • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan15 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Martijn Tonies15 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Juergen Sauer15 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Martijn Tonies15 Dec
    • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan15 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Martijn Tonies15 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Matthew Stanfield15 Dec
    • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Curtis Maurand15 Dec
      • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan16 Dec
        • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Matthew Stanfield16 Dec
          • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan16 Dec
    • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan16 Dec
      • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Matthew Stanfield16 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Vinod Kumar Singh16 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Martijn Tonies16 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Dr. Frank Ullrich16 Dec
    • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan16 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?David Griffiths16 Dec
    • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan16 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?David Griffiths16 Dec
    • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Chris Nolan17 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?mos16 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Martijn Tonies16 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Matthew Stanfield17 Dec
    • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Ed Leafe17 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Director General: NEFACOMP7 Jan
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Martijn Tonies7 Jan
RE: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Joshua Thomas15 Dec
Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?mos17 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Martijn Tonies17 Dec
Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?mos18 Dec
  • Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?Martijn Tonies18 Dec