System slowdown, DOS version of FP

Bill Vermillion fp at wjv.com
Fri Jul 2 16:41:31 PDT 2004


Shakespeare wrote plays and sonnets that will last an eternity, 
but on Fri, Jul 02 19:30 , Jay R. Ashworth wrote:" 

> On Fri, Jul 02, 2004 at 04:20:13PM -0400, Joe Acquisto wrote:
> > The problem manifests as some, and only some, PC's begin to "print
> > slow". What seems to be happening is that, when printing and invoice
> > (or whatever), it takes forever (for some PC's) to sequence thru the
> > records to "co-alese the vapor" and send the print job out. One can
> > see the "records scanned" number sequence very slowly on the problem
> > PC's, but quite smartly on the ones that are OK. Once the last record
> > is found (???), and the print job is submitted, it prints normally. It
> > seems to take a couple of days for this slowness to to begin again.
> >
> > >From what I can gather, the FP program stuff is on each PC, with only
> > "the data" residing on the file server.
> 
> That's the way it works, yes.
> 
> >                                       I can see, I think, that there
> > are few, or no, FP (pf***) environment variables set on the PC's, but
> > I do not know if that is significant.
> 
> "It Depends".<tm>
> 
> > I know that MS access, for instance, requires huge amounts of file
> > and record "locks" to be allowed on the file server, far beyond the
> > defaults. I would not expect this in a "real" relational database
> > environment.

> Neither would I.

> Alas, filePro *isn't* "a real relational database environment", by
> which, I believe, you mean "something where the clients send queries
> to the server, and the server sends back the set of records that
> comprise the answers."

And that's not really the definition of a relational database if you
used the 12 rules that C.J.Codd put forth in 1985.  Of course
almost no database ever got all 12, but many databases sold as
'relational' weren't by any stretch of the imagination outside of
the sales department.

Bill
-- 
Bill Vermillion - bv @ wjv . com


More information about the Filepro-list mailing list