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

Hi :)
I thought that the Calc route just read the data that is contained in the database?  I didn't think 
it converted it or export-imported it or dragged it in, i just thought it was another way of 
accessing the data.  Also i kinda had assumed that the Calc route would allow you to view Queries 
in the same way as you access normal tables.  

I don't really understand everything in Andreas' links but it seemed to fit in with what Girvin was 
asking for.  Quite a few people here have been extremely helpful to people using Base but i only 
remember Andreas going on about the alternatives to the Report Builder.  Possibly Alex, Drew, Dan 
and others have mentioned things too but i just hadn't remembered anything i could find reliably.  

It would be really good if a few of you experts in Base could write it up, maybe help Dan or expand 
on the work he has done.  

In response to Andreas' "How would you write a guide for hammer, chisel, plow, saw and file?" 
http://www.wikihow.com/Use-a-Hammer-Safely
"It is estimated that some 50,000 Americans seek treatment every year as a result of a hammer 
injury".  I guess it's similar in other countries but <rant> [deleted] </rant>]
http://artofmanliness.com/2009/09/29/how-to-use-a-hammer/
"A lot of men today are clueless when it comes to tools." <rant re:sexist> [deleted] </rant>
http://www.instructables.com/id/How-to-use-Vavles-Hammer-Editor/
http://www.hammernet.com/tips.htm
I'll ignore the bladed weaponry and activities that most people have no idea about (eg how many 
people really plow these days?! lol)
http://www.wikihow.com/Organize-Files
http://zenhabits.net/how-to-simplify-your-filing-system-or-why-stacking-just-doesnt-work/
http://www.realsimple.com/beauty-fashion/skincare/hands-feet/file-shape-nails-00000000002331/index.html
http://www.ehow.com/how_2034410_file-nails.html
http://www.nailsmag.com/article/474/getting-nails-into-shape
http://www.wikihow.com/File-Metal

Just because you know something so thoroughly well that it seems easier than falling off a bike 
doesn't mean that anyone else can cope with any of it.  Usually people that make something look 
easy have broken it down and worked hard at each step to make it smoother and less liable to break 
or go wrong or streamlined for speed.  

Regards from
Tom :)  


--- On Sat, 26/5/12, drew jensen <drewjensen.inbox@gmail.com> wrote:

From: drew jensen <drewjensen.inbox@gmail.com>
Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
To: users@global.libreoffice.org
Date: Saturday, 26 May, 2012, 4:50

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

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