Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

On Sat, 2012-05-26 at 12:53 +0200, Andreas Säger wrote:
> Am 26.05.2012 00:47, Girvin R. Herr wrote:
> > As an update to my problem with Report Builder, my 1500+ record database
> > takes 94 pages of a Report Builder / Writer document. I put on my
> > patience hat and timed how long it takes to format the report, ready for
> > printing. As a baseline, it takes about 49 minutes to create the
> > original document. I cleared my preferences and re-entered them, using
> > mostly defaults and timed it again: 49 minutes. So it is not preference
> > corruption from previous versions. I then updated my java to 1.6u30 and
> > timed it again: 49 minutes. So, it doesn't look like Java is the
> > problem. I then went back to my original use of SQL from when I created
> > the report with the wizard, rather than using a query for the data and
> > timed it: 49 minutes! No matter what I do, it takes about the same
> > excruciatingly long time to build my report. What is really frustrating
> > is that there is no status popup to inform me of what it is doing. It
> > just goes out to lunch. Actually, it seems to initially create 128 pages
> > with header and footer, but no data, at the end of the first "sleep".
> > When the page status at the bottom of the writer window drops to 94
> > pages, I know it is done. Every so many pages, it does come back alive
> > for a second or two and then goes out to lunch again for several
> > minutes. Each time it returns, a few more pages are populated with data.
> > Girvin
>
> Every time when there is a performance problem with this office suite, 
> Tom blames Java. It has to be Java just because Java is evil.
>
> Now this may be related to the one and only Java related performance 
> problem and Tom does not even notice.
>
> You are running the combination of Linux, Base plus JDBC?

Ah I missed that last bit - yup, those JDBC connections can suck - has
the OP tried ODBC?

//drew

>



-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted