Hi :)
I have just done a bit of digging around.
Looking back through Andreas' answers
http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodes&user=254826&i=80
I found this but i'm not sure it's much help for you
http://nabble.documentfoundation.org/database-td3926217i20.html#a3928210
This one seems to expand on the useful line at the end there
http://nabble.documentfoundation.org/Base-3-5-2-2-hangs-td3910280.html#a3911654
This one is a bit of an overview with nothing specific but might be useful to skim through for ideas
http://nabble.documentfoundation.org/Address-Books-td3829696.html#a3832514
This one looks brilliant to me
http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3819387
There is some documentation at
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
and an FAQ (translated from the French team's) at
https://wiki.documentfoundation.org/Faq
Sadly most of the people that know a lot about the ins-and-outs of Base are unwilling to help write
the Base guide so it's down to 1 person who is desperately busy with a lot of other projects.
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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.