SBarnes wrote:Does the Large Transaction Mode that existed in 6.5.13 exit in version 7 or is there a plugin that does it?
No - we never implemented that because version 7 is a lot more performant in displaying transactions, and also because the 2 forms which had this Large Transaction Mode - creditor maintenance and debtor maintenance on the transaction tab - have alternate forms to manage transaction allocation which cope with large transaction sets by not trying to display all of them but instead have the user select an invoice or credit and then select the corresponding transaction to allocate to.
I'd like to learn more about the issue you're having - we might be able to do something via a plugin, or improve things in the standard software.
SBarnes wrote:Is there also a way of limiting the result returned in a standard search screen as this is causing a speed issue for databases with either lots of debtors or lots of inventory items or how could you do this with a plugin and introduce paging?
Search forms (that is the Jiwa search dialog) use server side cursors, so we only return the rows which are able to be displayed within the confines of the current form size - you can't get much more efficient than that. If you are having performance issues with the search dialogs then I have a lot of confidence that some server side tuning of indexes / statistics can be done to improve things for you.
A couple of things to try (If you've not done so already) is:
There is also the rebuilding of database table statistics, which I personally have seen a few times to improve performance a great deal - but we don't have an article for that it seems. I'll circle back when I've created the article and post a link to it here.
EDIT: I've updated the article
Slow performance when retrieving data to include a section on how to rebuild table statistics.
Mike