Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MySQL
Message
 
À
17/04/2002 15:30:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: MySQL
Divers
Thread ID:
00634559
Message ID:
00646063
Vues:
26
Hi Hilmar,

A couple of years ago I switch over over to postgres from MySQL. At that time MySQL was limited to 2 GB tables or 4 GB tables depending on your operating system. If MySQL has been improved to handle TB size tables, then scalability is not an issue. I pulled the following from the postgres 7.1.2 doc:
Limitations of PostgreSQL

Maximum size for a database             unlimited (60GB databases exist) 
Maximum size for a table                64 TB on all operating systems 
Maximum size for a row                  unlimited in 7.1 and later 
Maximum size for a field                1GB in 7.1 and later 
Maximum number of rows in a table       unlimited 
Maximum number of columns in a table    1600 
Maximum number of indexes on a table    unlimited 
  
Of course, these are not actually unlimited, but limited to available disk
space and memory/swap space. Performance may suffer when these values
get unusually large.
Just out of curiousity does anyone know the limitations of MSQL and Oracle?
Leland F. Jackson, CPA
Software - Master (TM)
smvfp@mail.smvfp.com
Software Master TM
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform