is there maximum number of entries in one database file in libre BASE ?
in one .odb file ?
Is ther filesize limit to libre BASE?
Many thanks.
It depends on the size of each row and how much memory is available. Take a look at HyperSQL Database Engine (HSQLDB) / Discussion / Help: Maximum number of records in memory table.
Hello,
In addition to the comment by @jimk you should also be aware of a few other items. First understand Base is NOT a database. LO, by default, comes with HSQLDB Embedded as the default database used in Base. This does not mean you need to use it. Many different databases can be used by Base thus changing the amount of data possible. One example is embedded images. In the embedded DB, as few as 7 to 10 images can crash the DB. Not so in other DB’s.
Also, if talking about size, the embedded database is not recommended for anything but testing, learning, demos and maybe a few other possibilities. It is preferable to change to at least a split database where the data in no longer contained within the .odb file. With a split or other type of database, the chance of data corruption is greatly reduced.
For more info on using different databases in LO, view the documentation found here. Chapter 2 & Appendix contain relevant info. Also see the document in my answer here - Split DB setup instructions which may be of some help.