oooooooooooooooopsSorry my error. Yes I did just use the report wizard. I downloaded the Sun Report Builder and tried again. Sorry have to put details just in case I did something stupid. With BASE - open same JDBC connection to MySQL. Insert - new report Select table I want to use from the options in box at the right hand side of report (same table 8000 rows ish) report output = text, page setup = landscape same variables as before. 3 grouping variables(so have 3 boxes on the left side above the details box) 4 variables dragged into details area did nothing with headers and footers Has so far been running for 14 minutes...........will be ending the task now. I think there could also be some issue with the report builder! Darren
> Date: Thu, 11 Oct 2007 13:43:57 -0400> From: [EMAIL PROTECTED]> To: > [email protected]> Subject: Re: [dba-users] Report Builder > Performance> > Darren Norris wrote:> > Hi Ariel, Ran a report usng JDBC > connection to table in MySQL. Table with 8000 records. Selected 7 fields (mix > of varchar, number, date and integer).Labelling option- accepted all > defaults.Group- by 3 variables (date, integer, varchar)Sort options- accepted > all defaults (sorted by the 3 group variables)Layout = defaultcreate a static > report 228 ish pages done in < 5 seconds. Not a direct comparison but to me > suggests problem lies in HSQLDB> > (no idea if there will be a linear > relationship with table size / number of rows and am definitely throwing in > the I'M A USER NOT A TESTER / DEVELOPER TOWEL sorry).Darren> > > Hi Darren, > Ariel, Frederick> > Darren, it sounds like you actually used the report > wizard and not the > report builder, since there is no 'default layout' in > the report builder.> > Ariel, I followed the link to the mailing list entry > and if my very weak > Spanish isn't failing me to badly I believe the > original poster refers > to a blog's tutorial as the reference for his > actions. ( It's easy to > pick out hyper links in any language ) That bog > entry, by Solveig > Haugland, and the attached pdf file also shows the use of > the wizard and > not the SRB.> > So it may be a case, at least from the > reporting tool stand point, of > mixing apples and oranges.> > None the less > Darren's email does go to the heart of the matter > regarding the difference > in data storage engines used.> > Drew> > > ---------------------------------------------------------------------> To > unsubscribe, e-mail: [EMAIL PROTECTED]> For additional commands, e-mail: > [EMAIL PROTECTED]> _________________________________________________________________ Feel like a local wherever you go. http://www.backofmyhand.com
