I spent too much time to not answer the meanwhile locked How to import a big amount of data into LibreOffice Base - #12 by rdiez
Same Ubuntu version as yours with the latest LO.
- New database table in embedded HSQL:
CREATE TABLE T (A CHAR(1), B TINYINT, ID INT IDENTITY);
- Spreadsheet with =CHAR(RANDBETWEEN.NV(65;90)) and RANDBETWEEN.NV(0;255) in A1:B250000
- Copy A1:B250000 and paste to the table icon in the database window.
- Dialog: Append data to table T, no column labels, [Create]
- Minimize the LO windows to avoid stupid messages like “LibreOffice does not respond”. They have nothing to do with LO. It is the environment which can not distinguish busy from hanging. It remains silent when the app in question runs in the background (not active window).
- Do something else. After 10 minutes I came back and queried SELECT COUNT(*) FROM “T” and the answer was 250,000.
- Trying to close and save any view on that database, Base tries to wrap the whole binary thing (> 5 MB) back into the database and Ubuntu tries to tell me again that this application hangs.
- I lose patience, let Ubuntu kill LO, start again but this time I do not click anything in the Base window in order to avoid “installation” of the embedded database (yes, embedded databases install into a temp. directory which causes all the trouble).
- I call my Python macro to convert the database into an external HSQLDB and all the trouble is gone. I can query, edit, delete record sets in the Base GUI quickly and without problems. Apache OpenOffice Community Forum - [Python] Macro to extract and reconnect embedded HSQLDB - (View topic)
Lesson learned: Do not use any type of embedded database except for small demos. Use an external relational database such as PostgreSQL, MySQL, HSQL, H2, whatever works well with Base as a frontend. Firebird is not type compatible with Base as mentioned by @Ratslinger.
EDIT: Link to my test database t77775.odb
Download and extract the zip to a trusted directory according to Tools>Options>Security>[Macro Security…]. Open the database document. The embedded macro connects the document to the t77775.* files in the database folder using the HSQL driver of your office suite. Open/edit the table, run queries, do what you like.