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

On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote:
> drew jensen wrote:
> 8><...
> > Hi Tom
> >
> > Really - you seem to know a lot, are you writing a manual?
> >
> > @Girvin - there is no place that I've seen the report builder be that
> > slow and not have an installation problem - not saying it is impossible
> > but sounds really odd. 1500 records in a tabular report, 49 seconds is a
> > long time for that actually. There is one exception to that, graphics -
> > is your report including graphics stored in data fields?
> >
> > On the other hand Calc, as has been pointed out, might be your preferred
> > path.
> >
> > Best,
> >
> > //drew
> >
> >   
> 8><...
>
> Hello Drew,
> I understand what you are saying, but I installed the LO 3.5.2 binary 
> (RPM) packages from the LO website.  I repackaged them for Slackware, 
> but that does not change the 1s and 0s, just unpacks the RPMs and 
> re-packages the files into a Slackware package for installation.  
> Therefore, if there is an installation problem, it seems to be in the LO 
> packages.  Note that I am using the Report Builder bundled into LO, not 
> the version from the extensions website.  I do believe the newest is 
> 1.2.1 rev 2, and the one in LO is still 1.0-something.  I have not tried 
> to replace the bundled version with the 1.2 version.
>
> I could live with 49 _"seconds"_.  However, it is taking 49 _minutes_ 
> for my report.  My database is nothing special, just text and integer 
> values.  Nine elements plus the key per record.  No graphics.  So, yes, 
> this problem does sound unusual.  However, I have not been able to pin 
> down the problem yet.  In the meantime, I am looking into using Calc to 
> print my data.  It looks good and will do until I can get RB working.
>
> BTW: The report is a simple text page header, Detail, and page footer, 
> no graphics there either.  I do have the date and time fields in the 
> header, but that shouldn't bring it down.  Actually, I do have some 
> separator lines inserted at the bottom of the header and the bottom of 
> each Detail line.  Page number at the bottom of the footer.  That's it.
> Thanks for the help.
Hi Girvin

Sounds like it aught to run lickity-split...hmm

Anyway - looks like you are off to use Cacl.

You might want to do this.

When you open the data window under Calc, instead of copy/paste from the
data grid - grad, drag and drop the actual query name from the left side
of the data window. This will create a named range, you can set options
on the range to _not_ save the data in the spreadsheet, jut the
connection information...then when you open the spreadsheet again it
will re-run the query and update the data anew..

Best wishes,

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