Skip to site navigation (Press enter)

[RBG7-L] - Re: Printing Performance in Multi User Environment-V7.5

jan johansen Fri, 23 Sep 2005 05:34:24 -0700

John,

Sub-reporting will be slower due to the nature of it. I mean that you have all the functions available in the sub as in the main. And you can have multiple subs. So its like a having a pass setting set to multi-multil-multi.

I would check all your indexing to make sure they are proper. But that is about all I can offer.

I haven't downloaded the new update yet so maybe thats in there.

Jan

-----Original Message-----
From: "John Docherty" <[EMAIL PROTECTED]>
To: [email protected] (RBG7-L Mailing List)
Date: Fri, 23 Sep 2005 14:21:17 +1200
Subject: [RBG7-L] - Re: Printing Performance in Multi User Environment -V7.5

Jan,

Having just set up my first report using a sub-report I find the printing to be extremely slow. It is not the network though, CPU utilisation for RBG75.EXE is at 50% and the report does take a while, to say the least. Are you aware of anything one should, or shouldnt do to improve performance ?

Regards

John Docherty

From: [email protected] [mailto: [email protected]] On Behalf Of jan johansen
Sent: Friday, 16 September 2005 11:23 p.m.
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: Printing Performance in Multi User Environment -V7.5

John,

Was this a report that utilized sub-reporting?

If it is, I reported this behavior about a month ago by phone with Razzak.

You are right in that the second connection did not have to be doing anything.

As soon it connected, reports went from 5 seconds to 5 minutes. This was only

on sub-reports. Other reports seemed to operate just fine.

Jan

-----Original Message-----
From: "John Docherty" < [EMAIL PROTECTED]>
To: [email protected] (RBG7-L Mailing List)
Date: Fri, 16 Sep 2005 10:51:59 +1200
Subject: [RBG7-L] - Printing Performance in Multi User Environment - V7.5

I have noticed that when printing reports with more than one user connected to a database the performance is extremely slow, reports that otherwise take seconds to print, taking minutes. (This is even when the other user is not actually doing anything.) Scratch files are set to reside on the individual PCs, both of which are running XPP. When I look at Task Manager the RBG75 process is using only about 3% of the CPU, (system idle is the only other significant process at 97% or thereabouts). Network Utilisation is about 56%.

If anyone has any ideas or suggestions as to what can be done to improve this, that would be much appreciated.

Thank you.

Regards

John Docherty