Razzak and BIll
That makes sense why the 64 bit taking more space.
I do have the report set to 1 pass, but I am not sure how normal
my DB is. I was hoping I could just convert to V8 and spend my time
on adding cool features but I may have to redo some of my old code.
This is the app that is going up against up SQL Exp and .Net.
Wish me luck
Marc
--------------------------------------------------
From: "A. Razzak Memon" <[email protected]>
Sent: Tuesday, May 05, 2009 11:47 AM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - Re: 7.5 vs V8 speed
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.
