Re: Base Size Limits?

On 2010-03-23 19:03:46, Max Wagner wrote:
> Hello,
>
> I am considering switching from MS Access to the open office base program and I am wondering what the database size limits are?  I can't seem to get a straight answer, I have heard 2GB to 8GB and everything in between, also is there a compression\archiving tool that can be used with base?
>
> Thanks for the help.
>
> Max
>
>

It depends on the way the data is stored. If you're using the default 
HSQLDB driver to store the data directly inside the ODB file you can 
change a setting to have the file limit increased from 2GB to 8GB.
See this: http://www.oooforum.org/forum/viewtopic.phtml?t=49254

If you use another driver (e.g. MySQL, FireBird, PosPre, etc.) they have 
their own limits. E.g. MySQL depends on the operating system & file 
system in use:
http://dev.mysql.com/doc/refman/5.0/en/full-table.html

FireBird:
http://www.firebirdfaq.org/faq59/

PostGre:
http://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size_for_a_row.2C_a_table.2C_and_a_database.3F

For others do a google search on *DBMS Name file size limit*

Remember that (as stated in the OOoForum post) it depends on your use of 
this database. If you will have more than one concurrent user it's not 
recommended to use the internal HSQLDB driver, but use a DBMS which is 
designed for multiple users. Similar to Access not being recommended to 
use its internal ADODB driver, but rather link to a MS-SQL data source.

-- 
Regards Irné Barnard