Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Poor performance with Oracle JDBC | ||
---|---|---|---|
Product: | Base | Reporter: | nephila <nephila> |
Component: | code | Assignee: | dbaneedsconfirm <needsconfirm> |
Status: | CLOSED IRREPRODUCIBLE | QA Contact: | issues@dba <issues> |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues, kluck-buchholz, whooey1830 |
Version: | 680m122 | Keywords: | needmoreinfo, oooqa |
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | Linux, all | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
nephila
2005-08-16 14:49:15 UTC
clu->fs: fits in our performance improvement task back into pool fs->clu: Can you confirm the behaviour described here? change owner works fine for me with around 100 tables - may try it on a current version (2.2 or newer) 1. how long does it take approx? 2. what jdbc driver do you use? 3. do you have the possibility to take an other driver? 4. do you habe the possibility to connect a 'smaller' database? thx Since I filed this report I've changed jobs and now have a different database, it's still Oracle only now it's ~4000 tables in the schema I've logged into! Unfortunately I'm still experiencing performance issues. The database server itself is running on a fast SPARC/Solaris machine and performance in other JDBC applications (Oracle SQL Developer) with the same driver is sadly much better than OOo. My previous workstation was much slower, but it's still dragging along on this one. The database is Oracle 10g Release 2, whereas previously I was using Oracle 9i Release 2. This time I'm running the tests from WinXP using the 2.3 developer snapshot m210. To answer you questions: 1. It's been 10 minutes to get a table list. 2. Oracle's ojdbc14 driver version 9.0.2.0.0 oracle.jdbc.driver.OracleDriver 3. I'll try the 10g instant client driver (version 10.2.0.2.0) 3.1 This time it took 27 minutes. 4. Unfortunately I don't have a smaller DB to connect to. I'm experiencing similiar problems (OO 2.2.1, Oracle 10g, ojdbc14.jar for 10.2.0.3). After entering name and password, OO starts to get the list of tables which takes aprox. 3 minutes. The user itself only has a few tables, but also a large number of system tables is included in the list, which makes progress slow. Both client and server are fast machines, system load on the server is neglectible, system load on the client varies between 20 and 100%. There's continous network traffic on port 1521 between client and server so network timeouts shouldn't be an issue. Another annoyance is that number fields are still displayed as currency. This is an old but still not resolved issue (http://www.openoffice.org/issues/show_bug.cgi?id=11746). A quick and dirty workaround could be to exclude tables and views of user who are called *sys. Better would be to include another level in the tree (tables/user/tablename) instead of table/user.tablename) which would provide a better overview. Thus, the list of users would be fetched first (should be quick) and the list of tables after an user entry is chosen. can someone provide a link to a virtual machine which has oracle preinstalled?? i suppose more people would be trying to reproduce this issue if they would just have to install openoffice into the appliance and would also be provided with scripts for creation of dummy tables and data. regards, brian does it also happen with the latest version? Performance has very much improved in my case (OO2.4, ojdbc14.jar for Oracle 10.2.0.3). Opening the list of tables used to take 3 minutes, now it takes 10 seconds. Thnx. => so i see this one as fixed (at least the basic problem) - for any further stuff (specially speed problems in a current version) please write a new issue thx => close |