|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 18th, 2006, 04:56 AM
|
|||
|
|||
|
Max table size and DB size in Firebird
 I am new to Firebird. Does anyone know what are1.the maximum size of a table 2.the maximum database size of Firebird 3.the maximum number of tables in one database Is there any website about the specification of Firebird? Thanks in advance. 
|
|
#2
August 18th, 2006, 05:11 AM
|
||||
|
||||
|
The teoretical limits are far beyond the level attainable by anyone who asks such a question (this is based on my personal experience
 ).However might want to read the old limits, note that Firebird 2.0 (now very close to production quality) has rised them. Theoretical max table size is 32 TB.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#3
August 18th, 2006, 10:04 PM
|
|||
|
|||
Thank you so much.
Firebird is so powerful. It is far beyond the limitation of MS Access which its limitation is only 2GB for the whole DB. Though Firebird is free to use, it's much better. 
|
|
#4
August 19th, 2006, 01:19 AM
|
||||
|
||||
|
Note that a database can be made of many smaller files instead of a single huge one, this makes everything more manageable.
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Max table size and DB size in Firebird |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
