[Libreoffice-bugs] [Bug 115314] New: base connection to Oracle db is slow

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=115314

            Bug ID: 115314
           Summary: base connection to Oracle db is slow
           Product: LibreOffice
           Version: 5.1.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jkmin1 at gmail.com

Description:
I use LibreOffice 5.1.6.2 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.

Actual Results:  
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.

Expected Results:
Should be lot quicker than this


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/63.0.3239.132 Safari/537.36

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180130/2f424f0f/attachment.html>