General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only