Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Table limits, DBISAM vs ElevateDB
Sat, Jan 24 2009 11:20 AMPermanent Link

Kevin Killion

DBISAM has a table size limit of 4GB.  
Does ElevateDB have the same limit, and if not, are there any limits to the size of a
ElevateDB table or database?

THANK YOU!!!
Sat, Jan 24 2009 12:12 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Kevin,

> DBISAM has a table size limit of 4GB.  

This is not entirely correct.
In *both DBISAM and EDB*, there is a maximum file size of 4.000.000.000
bytes for any physical file (data, index and blob files) but only if you
have "LargeFileSupport" property disabled. With "LargeFileSupport"
enabled the limit is 128.000.000.000 bytes (only a little less than
128Gb) for each of the files.

Also, a table is not exactly the same as a file - it's data can be
stored in 1 to 3 files. Excluding index data, we can roughly say that in
the limit, a table can grow to about 128Gb if there are no BLOB columns
or about 256Gb with BLOB data.

All this is for *both* DBISAM and EDB under Win 2000 or later operating
systems. Under Win 95/98 and Linux the "LargeFileSupport" is not
supported and under Linux the limit for any file is 2.000.000 bytes.

--
Fernando Dias
[Team Elevate]
Sat, Jan 24 2009 1:28 PMPermanent Link

Kevin Killion
Great news, thanks!!!
Image