Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Khurram Tahir
  Where is Khurram Tahir?
 Khurram Tahir
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Pete Sass
Subject: RE: Slow Work
Thread ID: 393899 Message ID: 393960 # Views: 40 # Ratings: 0
Version: Visual FoxPro 9 Category: VFP and .NET
Date: Friday, December 27, 2013 8:01:45 AM         

> > 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)
> Hi,
> 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
> Main.prg.
> 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.
> www.marathongriffincomputers.com

On Every Workstation already installed VFP9SP2RT.exe

Now as you said that copy VFP.EXE and runtime files to every workstation OK

Please guide Folder Name as well as Path setting of VFP.exe in every workstation


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