I have a customer who has 53,000 items in their database... could this cause slowdowns?
When an item is added to a purchase order it takes roughly 1-2 seconds to appear in the list... this is my only customer with this many items and I'm wondering whether doing an item cleanup will resolve this issue...? Ideas?
*This post is locked for comments
I would recommend checking the size of your database. Were those items imported? large transactions? is it sql server 2005? We upgraded the server and it made a big difference. We also cleaned up the items and deleted 5+ year old transactions.
to resolve Slowdowns RMS lookups
1- Check database log (Shrink it if it's size very huge before shrink make its recovery mode simple)
2- Run Reindex database from store operation administrator and check database
3- Add some indexes to your database tables (item, etc...) if not all of above resolve your issue
Thanks. I will try that when store is closed remotely.
Before you run indexing on database close any related rms apps hq client and som
run check database and reindex it again
My HQ database doesn't have a StoreTaxes table. Maybe an add-on was installed/uninstalled.
Yes, it was originally deployed in HQ. RMS replaced an existing system for this business and they have 7 stores. No import tools were used.
That is why I asked how system was originally deployed in HQ and whether any SQL tools were used to insert data.
Your suggestion seems reasonable. Sort of surprised that the table is missing and that everything else is functioning...
Do You know what was the previous version, before CU5 was installed?? Any changes in the Tax data before the CU5 update? Do You maybe have a backup of the database before the CU5 update, so we can restore and compare? To be honest, this [StoreTaxes] table, makes me worry... do You have any 3rd party add-on installed maybe??? This error normally happends when a "object" in SQL database is missing...
Hope we are going to the right direction with the tip...
Regards, A.
Its at CU5 right now. Updates were deployed system-wide as they were available.
SQL 2008 R2
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156