Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TABLEUPDATE slow
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01135188
Message ID:
01135196
Views:
14
Thanks Jim

1) 1.8G, 256 RAM
2) As little as 2 can cause the slower speed.
3) 100MB network
4) No
5) 30,000 records and packed.
6) how do I check that Rushmore is active?
7) Trend Micro Client/Server Security Agent.

>Hi George,
>
>Some questions...
>
>1) What speed of workstation and what amount of RAM on them?
>
>2) How many workstations active with the database at any given time (average, max)?
>
>3) What speed is the network?
>
>4) Does the workstation with the database have other duties like printing?
>
>5) What are the sizes of the tables involved?... Any deleted records?
>
>6) Are you confident that Rushmore is active?
>
>7) Is there anti-virus running on the workstations?
>
>good luck
>
>>Hi. I have a VFP 5 Order Entry app. that uses optimistic buffering. Works well except when there are multiple users, where saving an order is very slow. A trace shows that it sits on the TABLEUPDATE(.T.) for upto 30 seconds. Any ideas.
>>
>>TIA.
George
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform