I’m trying to convert a FileMaker database to LibreOffice Base. The database consists of ~15000 records, most of which are text. I have constructed a postgresql database containing all of this information and it totals ~5.3 GB, 5 GB of which is images for one of the fields. Without these images Base seems to work fine connecting as a client; but what I want to do is display the associated image when a user opens the relevant record.
To that end I tried creating a form from my table including all fields. I’ve confirmed that this works as expected (the images display) when I have only a small number of records (I tested 100), but if I try this same thing with the full dataset, Base eats up all the RAM on my system (32 GB) and crashes. So my interpretation of this is that Base is loading the entire table into memory when what I would hope would happen is that it would only need to load the current record(s).
I am very much a novice to Base; is this something that is readily addressable?