Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Too slow
Message
From
15/05/2019 08:22:19
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Too slow
Miscellaneous
Thread ID:
01668630
Message ID:
01668630
Views:
86
Hi friends:

A few month ago I started to have problems with my program when add records to tables.

This happens at the end of the day when my system sends to server daily activity. There are up to 2 terminals and servers with W7 and W10 so I can't deduce is the OS.

For example 97 records are added in 22 minutes a day when yesterday took seconds and tomorrow will take seconds again.

Since there are 3 or 5 terminals is curious everyone take almost the same time when they do the process at the same time.

I tried eliminate FLUSH but nothing changed.

This doesn't happen in all, just a few clients. For the time it takes I think the problem is when try to lock record.

Well. My clients solve the problem leaving machines turned on all night and as I started control the time I find sometimes all the process in take till 2 hours..

Any ideas?

Thank you.
Next
Reply
Map
View

Click here to load this message in the networking platform