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.