Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MySQL
Message
 
To
17/04/2002 15:30:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: MySQL
Miscellaneous
Thread ID:
00634559
Message ID:
00646063
Views:
25
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform