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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
