Book a Demo

Author Topic: HTML Report generation performance - ORACLE  (Read 2495 times)

carolmika

  • EA User
  • **
  • Posts: 29
  • Karma: +0/-0
    • View Profile
HTML Report generation performance - ORACLE
« on: September 21, 2006, 12:48:14 pm »
Hiya!
I'm having performance problems with HTML Report when the repository is Oracle. It's taking at least 40 minutes!!!
The same repo, when transfered to EAP takes 7minutes!
Does anyone has the same problem?

Carol

thomaskilian

  • Guest
Re: HTML Report generation performance - ORACLE
« Reply #1 on: September 21, 2006, 02:20:14 pm »
I haven't tried this but the problem is likely somewhere else. EAP files are MS Access databases. Any other database is going over ODBC. So maybe you have a network issue?

carolmika

  • EA User
  • **
  • Posts: 29
  • Karma: +0/-0
    • View Profile
Re: HTML Report generation performance - ORACLE
« Reply #2 on: September 22, 2006, 05:12:30 am »
Hi,

The network performance & the Database Server performance is ok, our network staff monitored the performance at the same time that I generated this report.

My suspicion is that the report generator procedure using an EAP is different of DBMS repo; I think that is a question that only Sparxs Team can tell us...

Carol

thomaskilian

  • Guest
Re: HTML Report generation performance - ORACLE
« Reply #3 on: September 25, 2006, 01:59:26 pm »
You could ask for support via the Support page for registered users. Maybe the Sparxians can help you that way.