- This topic has 4 replies, 2 voices, and was last updated 1 week, 3 days ago by
.
-
Posts
-
My SI install has been slow for a while.
I recently updated to the last version 2023.0.7 and it got a little better but pulling up all the invoices is still very slow… Going from People>Customers to Money>Invoices takes almost 10 seconds which seems very very slow.
Is there anything that can be done to make this faster or is it just because I have 1000+ invoices?
Even loading the Customers is pretty slow although I only have 400 of themCheck the setting of the Invoice Display Days field in the SI Defaults screen. This specifies how many days in the past to display invoices for unless you request all of them. I added this when I noticed that having years of invoices did slow the typical retrieval and display on the invoices list screen. If this is set to 0, then all invoices are displayed every time. Mine is set to 366 so I get a years worth of invoices by default. There is a tab on the screen to get ALL invoices if you need them. For me, I very seldom need more the a years worth and displaying this is quite fast (virtually instantaneous for me). You may have a different volume of invoices but can tweak this setting to what works be for performance versus number of historical invoices regularly needed.
I haven’t done anything for customers I don’t have so many that it has been an issue. Not sure if you mark customers as enabled/disabled for active vs inactive customers. If so, I could add an option to display active customers only by default and an option then to show all customers. Let me know if you think that might help.
Thank you so much. This is SUPER helpful!
The Display Days settings is what I needed!
I keep all my customers always enabled (cause, as they say, sometimes they come back! 😉 so I wouldn’t need any options to show only enabled customers, but the 1-year worth of invoices did the trick!
I can always click All if I have to find older ones…The one change/feature request I would like to ask for/add is that the search should always work in ALL (entire database of invoices)… I’ve noticed that if I set the days to 365 it won’t search for older invoices… I think the display feature should not affect the search feature as that can create some headaches and confusion (if you forget you have set it to a year of invoices and you need to find an old one with the search function).
Unfortunately, the search option is a feature of the DataTables module that SI uses to render the tables on the various manage screens. It is limited to searching only the data retrieved by the current inquiry. Knowing this, I hope that over time you will come to know if you need to review all history or just recent and do an all inquiry first if needed.
Concerning the enable/disable option for customers. Disabled just means they don’t appear in the drop down list of customers for new/updated invoices (though if you are editing an invoice for a disabled customer their new still appears in the list). It also places them after enabled customers on the customer management table screen.
You can always re-enable a previously disabled customer if they show up in your shop again.
Thank you RRolwey for the explanation.
Should you find a way to make the search feature system wide in the future, I think that would be a great feature to add so that one can always search the entire database.
From the little PHP I know it should be easy to disconnect the search feature from the table and just run the search across all the fields of the database.
- You must be logged in to reply to this topic.
Recent Comments