So its been a while I’ve posted here, but its about time I gave some update.
Currently i have 3 stores who do between 500 to 2000+ invoices daily and there are some performance issues.
I think subconsciously i just lost steam posting issues, which is not good for the community, these updates are useful for development.
Subjects:
Overall performance:
System will generally grind very slow and buckle up in the evenings with up to 6 cashiers posting sales, on average there are about 20 to 30+ customers at every moment, sometimes it will totally halt and need to be restarted
POS:
Funny issues progressively occur, the pos script can easily display wrong totals, i.e. showing a figure above or below the expected total maybe due to an item being added or removed and the script doesn’t update, slip gets printed with unwanted item or wrong total
Stock and Inventory:
Most of the shops have to stop inventory operations by 5pm else everything may buckle up.
Observations:
The mysql gets so bottlenecked, I can see it pushing 70+% usage on each of 7 cores of a core i7 processor, new generation, ssd powered system; just on posting some incoming pos sales.
We have disabled perpetual inventory to prevent accounting updates but it only help a little for a short while.
I think the script reliance is so much, permit me to reference v6 again as until date it is almost, in fact totally problem free except that its relatively slower, but totally error free on pos transactions.
I still think some performance improvement work needs to be done and pos should be given some focus.
The issues are seemingly worse than when I reported v6, that was purely a speed issue,. But transactions were totally dependable.
We are being forced to reset the entire transactional data at the worst hit site while keeping a live image of the current system for access and reconciliation of current transactions