Marc,
This is a clear indication that the problem is in your view definition. What you have confirmed is that it is not the report printing that takes the time, but the retrieval of data from the view. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Wednesday, May 06, 2009 6:03 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 7.5 vs V8 speed Unfortunately Project Temp from View then Printing the Report is not much faster compared to the original way. Marc It sounds like you should do the PROJECT TEMP ... command from your view (include the WHERE clause in your PROJECT), base the report on the temp table instead of the view. Bill On Tue, May 5, 2009 at 12:47 PM, A. Razzak Memon <[email protected]> wrote: At 10:25 AM 5/5/2009, Marc Schluter wrote: The command below takes 2 times longer in V8 compared to the same code in 7.5. PRINT NewForm76D WHERE tr_date BETWEEN 1/1/09 AND .#date AND insco1 = 7 AND compnum = insco1 ORDER BY insco1, custnum, tr_date The report is based on a 6 tab view, Browse all from View using the same where clause only takes 1/4 the time compared to the Print statement. Leaving off the Order by does not make any difference. I am using a copy of the same DB converted to V8, so all data, reports and indexes are the same. I did notice that the #1 file was 46 k now it is 191 k and the # 3 file is almost double the size in V8. Is that normal? I am not sure what to look for next? Marc, In addition to all the good suggestions you have already received, take a look at your report for "Pass Settings". If you are not using the System Variables "Page Set with Description" option, such as [Page nn of nn], or DBCalcs with "Look Ahead" option, change the Report "Pass Setting" from "Two Pass" to "One Pass". Here's how: Report Designer | Main Menu | Report | Pass Settings This will definitely speed up the PRINT engine. Once you have made the suggested change, try the following command to PRINT the report: -- Example -- Start here PRINT NewForm76D WHERE Tr_Date BETWEEN 1/1/2009 AND .#DATE + AND InsCo1 = 7 AND CompNum = Insco1 + ORDER BY InsCo1, CustNum, Tr_Date + OPTION SCREEN|WINDOW_STATE MAXIMIZED + |ZOOM_TYPE PERCENTAGE + |ZOOMPERCENT 98 + |PREVIEW_CAPTION New Form 76D RETURN -- End here Hope that helps! Very Best R:egards, Razzak. --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
