Using fixed record for processing
Jose Lerebours
fp at fpgroups.com
Fri Oct 3 07:28:56 PDT 2008
Fairlight wrote:
> The honourable and venerable Jose Lerebours spoke thus:
>> I have never been a fan of using "record 1" or "any one fixed record" to
>> sit on and run reports nor any kind of process. This effectively makes
>> the process "single user" and that would be the ONLY time it should be
>> used. I hope that is the case with you.
>
> Negative. I use -sr %n where %n is a variable external to dreport. This
> lets me sit on $LICENSE_COUNT records as control and logging facilities,
> all at once--yet gives me one uniform place each from which to do variable
> -pf operations.
>
> One record -per specified number-, yes. Single user? Hardly.
>
I just would like to know if %n is always 1 or is it a variable number 1
to 999999999? If it is a fixed number 1, it is single user since only
one process will run at a time ... You cannot have two or more processes
running at the same time.
Did you read the rest of my post? I did provide a very clear scenario
where this is a valid concern. If you are using variable record
numbers, how is that fixed in the context in which I am referring?
Yeah, you can have a point-of-reference table with several thousand
records in it; have a script create a random number X thru Y and then
set %n so that your process sits in a available record. If this is what
your are doing, how is this different from simply adding a new record?
License count? I do not know how things are as far as license count with
filePro now a days but I though it was a count per *clerk/*report
instance not per how many records you open. That said, if nothing has
changed, and if you have 5 processes running or trying to run on record
1 versus 5 processes successfully running on 5 separate records, how is
the license count any different?
In the other hand, if the count actually happens once the "record" is
successfully opened or locked, then you are right, license count is less
if you sit on one record. I still believe that it is a better practice
to do otherwise ... Buy 10 more licenses (fpTech should support this
measure) and make sure your processes do not sit waiting around for an
employee to come back from lunch!
Jose Lerebours
http://www.fpgroups.com
954-559-7186
More information about the Filepro-list
mailing list