I would check the PC(s) that uses the application for the AV. Simple enough to disable it on one PC and see if the performance improves.
>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham