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