Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Pete Sass
 To: sandeep singh
  Where is sandeep singh?
 sandeep singh
Subject: RE: Slow Work
Thread ID: 393899 Message ID: 393904 # Views: 87 # Ratings: 1
Version: Visual FoxPro 9 Category: VFP and .NET
Date: Wednesday, December 25, 2013 5:38:47 PM         

> Hi Expert
> i run my Exe File on server computer its work fast
> when run this exe on Client computer with ( Map Network Drive ) exe run slow
> if same time open server computer and Client computer exe then very slow work on only client computer work
> please give me a idea to work with exe on networking
> i am use Map Network Drive to Create Shortcuts to exe on server computer
> please this better way to share exe file with network
> or others way to fast work to same time on network
> please help me Experts..........
> Sandeep Singh (Ludhiana)


One thing to do and one mistake to avoid . . .

One Thing To Do
Copy the VFP EXE and runtime files and have them installed on the local workstation
with only the centralized database + tables + CDX', etc. sitting up on the server in a
shared out folder. Make sure you have a path set to the server's shard folder in your

One Mistake Made For Network System Deployments
When considering any application with server side database you need to ensure you
properly design the core project. You would normally never in any fair sized system
bring all the records down the network to any local workstation.
All larger sized tables should be considered to be obtained via SQL Select statements
using WHERE condition. As an example, of event a mid-sized Point of Sales system with
40,000 to 100,000 records for a year, I normally may decide on populating the invoice
header and invoice details records only as a default select out the most recent 30
days of invoices. There could be other options to select invoicing history between
starting and ending date range, but possibly limited to an overall 30 days maximum.
Also, ensure there are index keys set on your most common Select with Where conditions
so the WHERE is optimized.

Pete "the IceMan", from the Great White North of Canada.


Slow Work Posted by sandeep singh @ 12/25/2013 2:37:10 PM
RE: Slow Work Posted by Pete Sass @ 12/25/2013 5:38:47 PM
RE: Slow Work Posted by Khurram Tahir @ 12/27/2013 8:01:45 AM
RE: Slow Work Posted by Stefan Wuebbe @ 12/27/2013 8:32:05 AM
RE: Slow Work Posted by Khurram Tahir @ 12/27/2013 8:47:33 AM
RE: Slow Work Posted by Stefan Wuebbe @ 12/27/2013 9:37:17 AM