Is there a way to create an index in LibreOffice base that will actually speed up the searches. I used:
CREATE INDEX IDX_FName ON “Contacts”(“FirstName”)
which was executed successfully (though required a re-start of Base due to an error message saying I was out of memory). However upon doing the exact same search as without the index the search took the exact same amount of time (A full 12 seconds, which will only increase as the database gets used more and acquires more records).
I have written queries which are faster but I had problems with that approach as well due to client-specific considerations (my client doesn’t know SQL, nor can he spell well enough for the exact match necessary for a parameter input query) See my other question here: Is it possible to put a wildcard search into a parameter input query in Base?
As always any input is greatly appreciated!