General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks, Dmitri. One of the servers had - and still has - disabled Windows Defender. I'll check anothers. Most of the time process last up to 1 minute - anyway it is too long - but there are days it is up to 1 hour.
You think I should check terminals?
Noway. Fortunatelly my clients have patience...
>I would check an Anti-Virus (disable it for testing). In my experience AV software always slows down the program.
>HTH
>
>>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.
Previous
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