Re: VFP Performance Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jan (Nomail_at_Nowhere.com)
Date: 02/01/05 

Date: Wed, 2 Feb 2005 08:53:16 +1100

Amil,

If you are running any anti-virus software configure it to exclude your fox
files. Watch your network switch and see what activity occurs, if no
significant load is evident then the problem lies on the file server.

I would echo Rick's suggestion to put the exe and all temp files on the
local drive. A further suggestion would be to try your app using native VFP
table access instead of views. Our app runs against a database around 300 MB
on a couple of our sites and there does'nt appear to be any significant
performance degradation as additional workstations join.

HTH
Jan

"Amil" <Amil@discussions.microsoft.com> wrote in message
news:D3B8F584-4CD0-4B4A-A8B5-CFDD06CB207B@microsoft.com...
> Hi all,
>
> This is a very general question and any feedback is welcome.
>
> We have an application that uses local views against a Visual FoxPro
> database. When we ran our application locally, both exe and data is on the
> local drive, the performance is good. Opening the application locally
> three
> times does not significantly affect the performance of the application.
>
> However, when we have the exe and data on a local area network, the
> performance drops significantly for every new user opening the
> application.
> Given that I was the first user to login to the application, the
> performance
> degrades for each new user. But, when all the other users logout of the
> application, the performance on my instance of the application never
> recovers
> back to the original performance. It still drags as if there are still
> other
> users logged on.
>
> LAN Setup:
> - W2K server
> - 1GB lan
> - Largest table size: 4MB
> - App creates a temp database to hold the local views located next to the
> exe (network).
> - SET ENGINEBEHAVIOR 70
> Again, ANY kind of feedback is appreciated, including: suggestions,
> recommendations, i told you sos, whatever.
>
> Thanks.

Relevant Pages

  • Re: Sqlserverce class not working when VB.Net application is running from network drive
    ... one app attempts to connect to a sdf file on a network share, ... possible that the database is already in use when you attempt to ...
    (microsoft.public.sqlserver.ce)
  • Re: Webservices - the way to go...?
    ... about your lack of secure network connectivity your between a rock and a ... To summarize the posts so far: you have a winform app. ... using a webservices data layer to handle all the database interactions. ... Upgrade your database to SQL Server. ...
    (microsoft.public.dotnet.general)
  • Re: .NET new executable
    ... Since there is no network access avaialble, I want to send my app to each ... then you update the data into database. ... If all you are trying to do is send some data to your SQL server, ...
    (microsoft.public.dotnet.general)
  • Re: Design question and databases
    ... I frequently store resource files inside the EXE - Xml files, html files, ... eliminate the "must deploy a database" requirement for an application, ... I'm in the process of designing a small app that will be used by myself ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: I need help in asking the right questions
    ... the way your app is written can either put off the inevitable for a while or lead you to it faster. ... if your app uses a lot of queries on network tables you are going to find it slowing down sooner rather than later. ... If you are going to use this app for any length of time and will keep adding a lot of data, the answer is to convert the back end to a CS database. ... it slows down terribly when moving from record to record. ...
    (comp.databases.paradox)