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

Hi :)
I think there is another way to build reports?  I think Andreas uses a different way inside Base.  
Other people seem to start with the report builder and then hack it around.  It might be worth 
search the archives to find how Andreas does reports!
Regards from
Tom :)  


--- On Thu, 24/5/12, Girvin R. Herr <girvin.herr@sbcglobal.net> wrote:

From: Girvin R. Herr <girvin.herr@sbcglobal.net>
Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
To: users@global.libreoffice.org
Date: Thursday, 24 May, 2012, 20:01



Andreas Säger wrote:
> With LibO 3.5 under Linux I can use any recent Java version without any issues. I tested 1.6.22, 
> 1.6.31 and 1.7. Any of these simply work with my Java databases.
> I avoid the report builder like illness. If you feel the need to dance with this software diva 
> then you should do all calculations, filtering, grouping and sorting in SQL leaving the only good 
> looking stuff up to the beast.
Andreas,
Thanks for your reply.  Report Builder (RB) has always been a "beast" to me too, but it is the only 
option I know of for printing my database data in a human readable form.  So, I have to live with 
it, at least until I find something better.  Before Base, I was using Rekall, which had some nice 
features.  But that Open Source version is no longer supported, so that option is dead.
I am using a SQL query to sort and provide all the data to Report Builder.  I am not using any RB 
grouping or filtering either.  It is just a "flat" data set for RB to pretty up for printing.  That 
is why I don't see why it is so slow.  All the real time consumers, such as sorting, are being done 
by MySQL.  Also, after writer displays my first page or two, it goes out to lunch again, as if it 
is recalculating everything all over again.  That is frustrating, since it locks up and I have to 
wait several more minutes for another couple-second window where I can scroll or kill it before it 
goes off again.
I will certainly take your experience to heart and your recommendation to update my Java.
Thanks again.
Girvin


-- 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


-- 
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