I use LibreOffice 18.104.22.168 in Ubuntu 16.04. I installed and tried jre1.8.0_74 jre1.8.0_152 jre1.7.0_80 openjdk 1.8.0_151. Also, I increased the memory for 300MB for libreoffice, and 50MB for per object.
When I sign in to a remote oracle 11g XE database on the local network with hr user(has sysdba role), it takes like 30 seconds or so to complete the login. After I get 50 or 200 initial rows from a table with select statemetn, if I go to the end of the table by clicking the end arrow with about 80K rows or so, it takes 4-5 minutes to retrieve the rows.
Steps to Reproduce:
1.connect to oracle 11G XE db on local network
2.sign in remotely with base to the oracle db
3.select rows from a table and then use the end arrow button to get last rows.
Logging in takes about 30 seconds
Retrieving or going to the last rows from a big table like 80K or so takes 4-5 minutes.
Should be lot quicker than this
User Profile Reset: No
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36
I posted the question on the LibreOffice forum https://ask.libreoffice.org/en/question/144199/base-to-oracle-database-connection-slow/
*** This bug has been marked as a duplicate of bug 63713 ***
The problem apparently comes from actively refreshing the cache of object metadata each time a connection is made. This is very time consuming. There is currently no solution to this problem.
(In reply to Alex Thurgood from comment #2)
> *** This bug has been marked as a duplicate of bug 63713 ***
After reading the contents of the bug, I see my bug filing is a duplicate. I could not find that filing when I searched the bug titles using my title keywords. Thank you.
(In reply to jkmin1 from comment #4)
> (In reply to Alex Thurgood from comment #2)
> > *** This bug has been marked as a duplicate of bug 63713 ***
> After reading the contents of the bug, I see my bug filing is a duplicate.
> I could not find that filing when I searched the bug titles using my title
> keywords. Thank you.
I noticed that LibreOffice 6 is out. Is this fixed in LibreOffice6?