Announcements
Hola, estoy experimentando lentitud en el sistema al momento de liberar lotes en la pantalla 08.050.00 registro de pagos.
Versión 7FP1 con SQL2008 R2
*This post is locked for comments
08 screens are AR. The tables I mentioned have records for each period. So if someone, as was the case for us, entered a payment received date of 03/03/3015 SL creates the 12000 future periods. Then when you post another batch to the current period it updates the closebal in CashAvgD for the period of the transaction, then it has to updated the future periods (12,000) of them.
Can you explain why this would affect performance? I'm so confused about that.
Hi, I would look for a future date in ARtran and\or CAtran. Fix that then delete the future records from CashAvgD and CashSumD.
No warrenty expressed or implied.
thx, google translater
Ayrin
Hola, me gustaría ver a una fecha futura en Artran y \ o Catran. Fijar que a continuación, elimine los registros futuros de CashAvgD y CashSumD.
No Garantia expresa o implícita.
thx, google traductor
Ayrin
This screen, and others, can be slower if the SQL transaction log is very large. Routine maintenance of the transaction log needs to be done to shrink that log file down in order to keep performance up.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156