Joined: 13 May 2012
|Posted: Sun May 13, 2012 10:50 pm Post subject: Slow ODBC-Connection to OOo.Base / Calc
I am working with Oracle and have a Problem.
I have an OpenOffice Calc spreadsheet which requests a view/table from a Oracle 11g database. The View has about 16000 lines and 10 Columns (number and strings) with "audit select" enabled on this view.
I am using the ODBC driver "Oracle in OraClient11g_home1" and tried "Oracle in OraClient10g_home1" too.
Every time i refresh the spredsheet it takes more than one minute to fill in the data from the database (Requesting the same view in PL/SQL Developer takes only 0,3 seconds.).
When i check the entries in dba_audit_object i see more than 16000 new lines Ö.ö (an entry for every line in the view).
Why are there so many selects for only one view? Is there a problem with the ODBC driver? or Openoffice?
How can i avoid such an amount of traffic? Is there a solution at all?
Thanks in advance.