Hi Ravi,

It sure looks like you've done all of the 'standard' stuff, and then some.

The following are just thoughts that might be worth considering as well:

1) You don't mention if the VFP8 is SP1. If it is NOT then you might consider applying SP1. In particular there was a 'slowdown' regarding buffered (with changes pending) SQL-Update/SQL-Delete that I think was fixed in SP1. Refer to: Re: SQL update in VFP8 Thread #799850 Message #799959

2) I wonder if 64 meg. (your workstations) might be a tad small for VFP8. We know that the VFP Team did fixes (and who knows what else) with CDXs and, given the volumes you speak of, it *could* be that they (now) require more RAM than did VFP6. Possibly SYS(3050) can offer relief here. I'm no expert on that.

3) I *guess* that your implementation of VFP8 did include some new functionality. Maybe if you described the nature of the changes someone might remember something in them that affected them.

good luck



>!!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!!
>
>We are facing problem of slow speed in VFP 8.0 application...
>
>Our network details is :
> Xeon Server with 2.0 GB processer
> 512 MB RAM
> 1 LAN Card 10/100/1000 MBPS
> 1 LAN Card 10/100 MBPS
> 3 SCSI Disk
> Window 2000 Advance Server
> Symantec Corporate Addition ver (8.1) Antivirus
>
>Our Client details is :
> 50 System connected with 365*24 hrs working.
> Window 98 SE
> Symantec Client Auto update from server
> 64 MB RAM
> LAN Card 10/100 MBPS
> Connected with swiches
>
>Our Database Size ( All are free tables ) :
> 30 Master Tables
> 60 Transaction Tables
> 15 out of 60 having more than 2000000 records
> We have entered more than 50000 records within 24 hrs and we keep only 3 months records in the tables
>
>Problem is :-----
>Earlier we are using Vfp 6 application and there is no problem regarding the speed ( average speed 10 records in 5-6 sec.) Now, we have compiled the same application in VFP8.0 and updated on the server. After 2-3 days, we found that the network goes slow down at the time of inserting the rocords ( average speed 10 records in 12-15 sec.). The records updating speed is normal, when we have entered the records from 2-4 system.
>
>To solve the problem we have implemented the following steps but result is nothing.:
> - We have removed the Anti Virus from the network.
> - We have changed the LAN cables.
> - We have installed the server again on different PC
> - As per server, The Network performance is 20-30% enhansce.
> - No frame/packet loss show by the server.
> - We have moved the application with run time DLLs from server to user's system.
> - SET TABLEVALIDATE TO 0
> - SET REPROCESS TO 0 Seconds
>
>Thanks to all
>
>Ravi Mehrotra