Share
ReportHola, 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
You’re offline. This is a read only version of the page.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
All responses (
Answers (