I am trying to do a search in a libreoffice database from a form using the search facility (magnifying glass icon)
Searching all fields takes around 7 seconds which is a very long time considering the size of the file and the speed of the machine.
I have already tried upping the memory settings to use for libre office to 1024MB and Memory per object to 60MB but no change.
I have tried editing the database to have small field sizes but it makes no difference to file size or search speed. I have done saves and reboots between tests.
Java Runtime Environment for java-220.127.116.11-sun
Libre Office version 18.104.22.168
Build ID: 8f96e87c890bf8fa77463cd4b640a2312823f3ad
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default;
Locale: en-GB (en_GB.UTF-8); Calc: group
Test file size 270kb 18 columns by 2113 records.
PCLinuxOS x64 KDE fully updated (works very fast)
Intel Core i7-4770K (8 cores) @ 3.50GHz, 256GB Evo SSD (system), 2TB HDD (data), 32GB RAM, GTX780
Any help much appreciated.