One of our companies is a reasonably heavy user of Sage Line 50 and I’m amazed how much it has slowed down in the last year and the key seems to be it’s database back-end. I don’t know what Sage use but I wrote a Management Information System for the company to give salesmen a history of a quotes, orders and invoices which accesses the Sage files through Sage’s own ODBC connector. When I first installed the system at the beginning of last year, it took 2-3 seconds to load a customer’s history. It now takes over 20s!
Having exhausted any straight-forward ways to speed Sage up, such as excluding it’s files from Anti-Virus scans and so on, I decided that I would take a snapshot of the Sage data twice a day into a MySQL database since the MIS doesn’t need live data, a few hours old is absolutely fine. The performance against the MySQL database is at least 100 times quicker than against the Sage data. The difference is staggering! Both Sage and the MySQL server on are the same physical machine and they are operating through the same network infrastructure yet MySQL stamps all over Sage in performance terms.
Anyone know what Sage’s database back-end is? Is it bespoke or just carefully disguised? Either way, it’s performance is pretty poor.
Sage performance is appalling. We were advised to upgrade from Version 11 to one which they actually supported. So I spent a whole day upgrading the data to V2009 and now I have had to restore EVERYTHING back to version 11. The performance was so bad using Actinic Link software to feed into Sage that it was not useable. 30 minutes to import 3 orders. It’s not the network (connecting locally) makes no difference (Connection using Sage Data Objects) the only thing that has changed is the version of Sage.
When this package finally moves from its proprietory format to something like SQL then I will consider upgrading.
I had thought of calling Sage for advice, but like others posting on the net, I don’t want to be told that I have to upgrade my network to a Gigabit net only to find that it makes no difference.
AJ