Performance

The following rates each function in term of performance you can expect:

F.A.S.T

A FAST (Financial Accounting Summarization Table) summarizes all financial information by financial period and week. As a result of this FAST database, Consolidated XL performs very quickly to get the Turnover or Balance at the end of the year, quarter, period, month or week exceedingly fast. This FAST table provides the functions rated A and B with data very Fast.

A++ Rating

These functions are simple calculations, and do not require a read from database.

Calc Functions : Get Period Name/Date, Get Company Info, Get Last Sync Info

A+ Rating

These functions Spill multiple values into the sheet in one call.

The =CXL.GLVALSPILL("COMP01","#ReportPL") or =CXL.GLVALSPILL("COMP01","#ReportBal") function can return a whole P&L or Balance sheet with one call. Run the wizard "Get GL Vales Demo" and look at the 4th example sheet it generates.

Spill Functions : CodesSpill(), GLValSpill(), AgeDebtTotalSpill() and AgeContactDebtSpill(), ContactSpill() and ContactBySpill(), ItemSpill() and ItemBySpill(), GLJournalsSpill() and ContactTransSpill() and StockLinesSpill(),

A Rating

The primary purpose of Consolidated XL is to produce consolidated chart of accounts, or chart of accounts analysed by Cost Centre/Department. Therefore the functions to get Balance/Turnover for GL Account are optimised to give very fast performance. When requesting figures for a Year the whole year for the chart of accounts, FAST table, are loaded into memory and then figures returned from that cached data from memory. Thus the response is optimal and very fast.

Functions : Get GL Turnover/Balance Histoy by Week/Month/Period (Optionally by Cost Centre/Department), GL Name, Receivable/Payable Debts, Predicted Future Receivable/Payable

B Rating

Turnover for each Customer/Vendor or Stock item, for each period, is stored in one record for optimal performance. Thus these functions give reasonable performance. But unlike A rated functions all history for a year is not reading one chunk from the FAST table, and then processed in memory.

Functions : Get Budgets, Contact/Stock Turnover by Week/Month/Period (Optionally by Cost Centre/Department), Stock Profit/Profit Margin, Currency Rate, Unrealised Currency

C Rating

Reads from database each individual Customer/Vendor or Stock item at a time. So performance may be OK for 10 -20 records in a query, but 5000 items will take a long time, hence not recommend.

Functions : Get Contact Info, Stock Info

D Rating

Must query table for every value. So performance may be OK for 10 -20 records in a query, but 5000 items will take a long time, hence not recommend.

Functions : Get Last Cost