Large Transaction Mode Revisited.
Posted: Fri Nov 10, 2017 11:29 am
Hi Mike,
A while ago I made a post about what had been Large Transaction Mode in 6.5.13 that was here https://forums.jiwa.com.au/viewtopic.php?f=26&t=819 and I have follow the advice you gave in terms improving SQL performance.
Unfortunately this hasn't helped much, so I was wondering how much you know about SQL's in memory features under SQL 2016 and if there is anything that can be done using SQL 2016 that might help improve performance further as this is a database with transaction in it going back to 2003 and the only other idea I have had is to try archiving some of the debtor transaction and sales data?
A while ago I made a post about what had been Large Transaction Mode in 6.5.13 that was here https://forums.jiwa.com.au/viewtopic.php?f=26&t=819 and I have follow the advice you gave in terms improving SQL performance.
Unfortunately this hasn't helped much, so I was wondering how much you know about SQL's in memory features under SQL 2016 and if there is anything that can be done using SQL 2016 that might help improve performance further as this is a database with transaction in it going back to 2003 and the only other idea I have had is to try archiving some of the debtor transaction and sales data?