Re: Using Native VFP Tables and Network Performance

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Do you have a large number of deleted records in any of the tables? Our
ordering website which is 100% VFP code logs new orders to a VFP table to
inform the user there is a new order. The user who monitors the log clicked
the "Clear Log" button on the form. Our website performance went from
sub-second response to 6-20 seconds per response. After I packed the table
the performance was back to normal.

In addition to the above website I have 35 users accessing the same set of
tables through VFP 7 and we have no performance issues.

Tom

"Jeff Grippe" <jeff@xxxxxxxxx> wrote in message
news:7rCdnQFHU8jMpGjanZ2dnUVZ_h2pnZ2d@xxxxxxxxxxxxxxxx
Hello and thanks in advance for the help.

We are using VFP 7.0 SP1 and native VFP tables. All users are running Win
XP Pro SP2 and our file server is running Win 2003 Server.

We are running a network with about 30 users. Each user has 3 or 4 VFP
apps open with each app opening up to 40 tables. Most tables have memo
fields so each table opens 3 files. There are some forms with private data
sessions that open their own copies of from 25-30 tables (with memo
fields). Some of these forms are opened and closed repeatedly throughout
the day.

Are there any performance issues with using VFP tables and Win 2003 server
as I have outlined above? We are attempting to figure out why we are
having network performance issues and it has been suggested that the large
number of open files caused by the configuration that I have outlined
could be impacting network performance severely. Does anyone know if this
could be the case or if there are special configuration issues for Win
2003 Server that should be applied when using a large number of native VFP
tables.

Thank you very much.

Regards,
Jeff





.

Quantcast