RSS Feed c9 logo Australia's best motorcycle shop retail software
Release 5.2.16 May 3, 2022 barney

Includes DB changes, you need to log all terminals out during upgrade

  • Tweaks and fixes
    • Bank rec and cash till : tweaked some times to improve database performance. Significantly snappier on systems I tested ( nested SQL procedures do not seem to be optimising well. Rewrote core query as plpgsql function, stored ref/prior rec ids in temporary variables. The resulting plan is essentially the same but it is significantly faster, suggests STABLE flag on prior/ref stored procs is not working as advertised and might be getting executed multiple times. Some more testing strongly suggests this is indeed the case )
    • low level v5 changed to help improve data migration tooling. (allow dbtool to hook into any JDBC database, not just c9 postgres. Improve performance of TrImport using cursors and some logic fixes on job batching not isolating self contained txn runs perfectly)
    • Couple of reports of add part to workshop triggering nullpointerexception. Problem likely caused by a closed table in a view which is triggered when keying in a part on order (pops select customer order screen). Added some guards to prevent tables from being accidently closed on main thread.