Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement