Tuesday, April 08, 2008

Is Sage Slow and is it their fault?

Sage 50 has a reputation for not scaling very well and suffering from poor performance on networks.

Until Sage change the backend to MySQL (next year?) they are always going to be hampered by the old flat file structure that it uses. No database technology here. In some respects it's amazing it works as well as it does.

But after spending years working with Sage Line 50, developing our own Sage applications and installing and supporting networks I believe a lot of users would benefit from making sure their systems are correctly configured before pointing fingers.

I see huge differences in Sage performance on very similiar kit. Often Small Business Server 2003 is maligned in this respect but with a proper benchmark on identical correctly configued software there was effectively zero difference between XP and SBS as a Sage Server.

We have recently written a test program that tests some aspects of Sage performance by reading all the Header Transactions and calculating a Rate per second to read a thousand records. With initial tests on just a few systems the result varied from 0.65 of a second to over 7 seconds. Our benchmark was 1.2 seconds on a Pentium 4 notebook configured as an SBS Server.

The program also checks some common configuration issues.

You can check out our test program at www.sbslimited.co.uk/sageslow.htm

Sage Line 50 and Microsoft Office Accounts 2008

Just when you thought it was safe to go back into the water along comes a new Accounting Package in the form of Microsoft Office Accounts 2008.

Despite being annonyingly slow it would seem to offer some huge benefits to the average small business, namely that it's free. Zip, Rien, Nothing.

Yep, the "Express" version can be downloaded for free. The Professional Version is £149 which gets you Order Processing, Stock, Multi Currency etc. And then you can add further users at £149 each.

Initial impressions are that it's fairly easy to use and if you are new to accounts no more difficult to learn than Sage 50.

A huge advantage is that it can allegedly handle Pay Pal transactions and simply import data from Excel spreadsheets.

Sage developers will be interested to learn the SDK is free, and that you can "hook" into the application itself, customise Labels on forms and add your own menu items and corresponding forms that can access data in the application itself. And it's free (I think I might have mentioned that already). Bad news is that you will have to finally learn dot net.

Downsides are probably that you won't be able to find an accountant who has it or knows what to do with it. Similiarly your average book keeper will run screaming from the room. Then there's the queston of Support which is something that Sage are (albeit expensively) quite good at. With accounts you have the dual problem of supporting users who may have problems with the actual software but also have absolutely no idea what a debit or credit is never mind a nominal ledger.

I predict that Sage will suddenly acquire some new features and pricing structure...