Project Tracker

I don't buy in to what you are saying. If that was true I would see it in
all areas. Such as reboot and the first time you load job tracker, etc... My
theory is: It is something to do with the program. It is not requesting jobs
for the project using the correct index. Or the inverse we are not using
Field Service and it's waiting and timing out on something.

Patrick

-----Original Message-----
From: william [mailto:william@...]
Sent: Thursday, November 01, 2001 7:00 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Project Tracker


This kind of behavior is typically associated with the distribution of
the records in the Database. The first time you run the function,
Progress must read all the records from the Disk, and they get written
to buffers in memory. Progress reads from the disk in blocks, so
getting one record inevitably gets more records that the one that is
actually required. However subsequent runs will find many of the records
required already in the Buffers, so no disk reads are required, and the
response is noticeably faster. How long a particular block stays in
memory has a lot to do with the number of users on the system, the type
of requests that they are generating, and how much memory you have
allocated with -B. Obviously other things, such as network traffic could
also impact response time, but from your description, This is a pretty
clear case of disk i/o versus memory i/o.

HTH.
"Winter, Patrick" wrote:
>
> Has anyone noticed or reported Project Tracker is slow to start.
> I tested this morning on our live database with just myself logged in
right
> after a reboot.
> Project Tracker took 40 seconds to load a project.
> After one project is brought up it only takes about 3 to 5 seconds to load
> another.
> Any input would be appreciated.
>
> Patrick Winter
> sSc Specialty Screw Corporation
> Vantage 5.00.317, Progress 9.1a
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Has anyone noticed or reported Project Tracker is slow to start.
I tested this morning on our live database with just myself logged in right
after a reboot.
Project Tracker took 40 seconds to load a project.
After one project is brought up it only takes about 3 to 5 seconds to load
another.
Any input would be appreciated.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.00.317, Progress 9.1a
This kind of behavior is typically associated with the distribution of
the records in the Database. The first time you run the function,
Progress must read all the records from the Disk, and they get written
to buffers in memory. Progress reads from the disk in blocks, so
getting one record inevitably gets more records that the one that is
actually required. However subsequent runs will find many of the records
required already in the Buffers, so no disk reads are required, and the
response is noticeably faster. How long a particular block stays in
memory has a lot to do with the number of users on the system, the type
of requests that they are generating, and how much memory you have
allocated with -B. Obviously other things, such as network traffic could
also impact response time, but from your description, This is a pretty
clear case of disk i/o versus memory i/o.

HTH.
"Winter, Patrick" wrote:
>
> Has anyone noticed or reported Project Tracker is slow to start.
> I tested this morning on our live database with just myself logged in right
> after a reboot.
> Project Tracker took 40 seconds to load a project.
> After one project is brought up it only takes about 3 to 5 seconds to load
> another.
> Any input would be appreciated.
>
> Patrick Winter
> sSc Specialty Screw Corporation
> Vantage 5.00.317, Progress 9.1a
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1