Sounds to me like it is the actual processing of the invoice at
the client machine that is the problem. Like you are bringing
too many records over the network to process. Either your SQL
statement isn't optimized or your "for clause" isn't. You never
notice it on your terminal services client because you are
actully doing all the processing on the server, and no records
are being sent over the network.
2. Shut off all Anti-virus software just to make sure.
3. Are all clients slow or just that one?
4. With FOXPRO 2.0 for DOS, there is a timeout setting in the XP
printer driver that has to be set in XP in order to allow it to
print quickly. Even though you are using Windows, I wonder if
playing with it will speed things up.
--- Alan Bourke <alan.bourke at qbs .D.O.T ie> wrote:
> VFP application with data residing on a Windows 2000 server, XP
> clients.
> 100Mb network They run it via a local EXE. In a particular
> section (creating
> an invoice) it takes 20 seconds after the point at which the
> user says 'ok
> save it' till it starts printing. Doing it via a Terminal
> Services client
> there is no lag at all. It just seems to be wherever files are
> actually
> being written to the server. There are resident virus scanners
> on server and
> clients, but the relevant app directories are excluded. Any
> ideas?
>
> Alan Bourke
> Opera Support And Development
> Quantum Business Solutions,
> Quantum House,
> Temple Road,
> Blackrock,
> Co. Dublin,
> Ireland
>
> Tel +353 1 2796666
> Fax +353 1 2832384
>
> http://www.qbs.ie
> http://www.aesop.ie
>
>
> Any views expressed in this message are the sender's own, and
> do not
> represent the views of Quantum Business Solutions except where
> the sender
> specifically states otherwise. Only those persons or entities
> to which it is
> addressed should read this e-mail. Quantum Business Solutions
> accept no
> liability for the consequences of any person or entity other
> than the
> intended recipient(s) acting, or refraining from acting, on the
> contents of
> this e-mail. If you have received this e-mail in error, please
> delete this
> document. Any form of reproduction, dissemination, copying,
> disclosure,
> modification, distribution and/or publication of this e-mail is
> strictly
> prohibited without prior agreement with Quantum Business
> Solutions.
>
> _______________________________________________
> Post Messages to: ProFox@leafe.com
> Subscription Maintenance:
http://leafe.com/mailman/listinfo/profox
=====
"I triple guarantee you, there are no American soldiers in Baghdad." Muhammed Saeed al-Sahaf (Baghdad Bob)
©2003 Michael Madigan |
