Ask Your Question
0

base to oracle database connection slow

asked 2018-01-26 22:28:53 +0200

jkm gravatar image

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. If I go to the end of the table with about 80K rows or so, it takes 4-5min to retrieve.

Is this normal? If not, what can I do to improve the performance.

Thank you very much

edit retag flag offensive close merge delete

Comments

Is the Oracle DB slow when used directly, or only when used from LibreOffice Base?

Jim K gravatar imageJim K ( 2018-01-27 19:42:17 +0200 )edit

I think it is slow only when used with LibreOffice Base. I tried remote sqlplus connection and fetched all 78K rows within a minute. I tried sqldeveloper and it seemed to retrieve all the rows fast by scrolling down the slider on the right continuously. Thank you very much.

jkm gravatar imagejkm ( 2018-01-29 19:43:17 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-01-29 22:11:00 +0200

Ratslinger gravatar image

updated 2018-01-29 22:32:49 +0200

Hello,

Have spent last few days (on & off due to frustrating installing of various bits) testing this.

11g XE was installed just locally and no remote testing was performed but results were somewhat the same. Using JDBC, from Base the sign does not seem to be the problem. If an incorrect password was entered the response was almost immediate. However, if the sign on was correct it took about four minutes to retrieve anything concerning tables. During this period nothing else in LO could be performed. Nothing on the Base file which was open and could not open anything else in LO such as a Calc document. Once the process completed, most functions were normal. The same wait occurred when performing a View->Refresh Tables or Tools->Table Filter....

Most time was spent trying to get ODBC connection working. Finally got working today & instant results within Oracle. However, in Base get error that it can't find the driver.

Access from sqlplus or SQL Developer (Oracle) or even the Getting Started seem to present no problem with delays in DB access.

Have also read about older Java working on AOO 3.x. Tried Java 1.6.0_21 but no better result. Even tried in AOO 4.01 Base but again same result. One somewhat noticeable difference was openjdk was about a minute slower than Oracle JRE both in LO & AOO. Openjdk was about four minutes while Oracle 1.8.0_151 was about three minutes in each. Another weird point in LO only was about halfway through the wait, tasks area of Base went blank. Both LO & AOO had a core usage surge about this time but only LO went blank. When tables were displayed the tasks were also.

All testing was done with LO v5.4.3.2, AOO v4.01 on Mint 18.3 & Xubuntu 16.04. Also did some brief testing on Mint using LO v4.2.8.2.

From all this, it appears a Bug report should be filed. Don't know where exactly the problem lies but there seems to be multiple problems involved and probably goes back to Open Office or even prior.

edit flag offensive delete link more

Comments

Thank you very much for spending time and confirming the problems I have. After entering userid and password for the Oracle db, retrieving table list takes about 30 sec or more. After that if the table is tiny, there does not seem to be any delay. How do you file the bug reports. I am totally new to this. Thank you.

jkm gravatar imagejkm ( 2018-01-29 22:25:49 +0200 )edit

@jkm You can file on Bugzilla.

Ratslinger gravatar imageRatslinger ( 2018-01-29 22:31:36 +0200 )edit

I filed the bug report on Bugzilla. Thank you.

jkm gravatar imagejkm ( 2018-01-30 19:57:30 +0200 )edit

@jkm Thanks for the info. It is good to let others know the related item.

The reported item is Bug 115314 - base connection to Oracle db is slow.

Ratslinger gravatar imageRatslinger ( 2018-01-30 20:42:32 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-26 22:28:53 +0200

Seen: 436 times

Last updated: Jan 29 '18