[DBTech] DragonByte Shop [Paid] 7.2.2

[Empty]

Is there an expected upper limit of items to be allowed in the store before we can expect a performance hit? I added a lot of items about a week ago and since then my forum has been loading slowly, been trying to nail down what the issue could be, since this was the only change I'm wondering if I added too many items. We have nearly a thousand items.

 

[DragonByte Tech]

Is there an expected upper limit of items to be allowed in the store before we can expect a performance hit? I added a lot of items about a week ago and since then my forum has been loading slowly, been trying to nail down what the issue could be, since this was the only change I'm wondering if I added too many items. We have nearly a thousand items.

I have not received any reports about scalability issues that I can recall If you can, enable debug mode for your user only (method depends on how you run XF, and there might be addons for it) and check the SQL queries for any slow queries.

 

[Empty]

I have not received any reports about scalability issues that I can recall If you can, enable debug mode for your user only (method depends on how you run XF, and there might be addons for it) and check the SQL queries for any slow queries.

Thank you so much for your quick reply and helpful response. Your suggestion to use debug mode helped me confirm that the slowdown I'm seeing is almost certainly related to database queries. I was able to identify another addon that was likely contributing, but I found that that the xf_dbtech_shop_item table seems to be performing a "full table scan" (the log mentioned Type: ALL) on every page and on my forum is the slowest loading query. That seems to explain why the issue only appeared after I added nearly a thousand items to the shop. I wonder if theres a way that an index could be utilized for improvements on page load? Since the full scan causes a performance hit on my forum. Just spitballing.

 

[DragonByte Tech]

Thank you so much for your quick reply and helpful response. Your suggestion to use debug mode helped me confirm that the slowdown I'm seeing is almost certainly related to database queries. I was able to identify another addon that was likely contributing, but I found that that the xf_dbtech_shop_item table seems to be performing a "full table scan" (the log mentioned Type: ALL) on every page and on my forum is the slowest loading query. That seems to explain why the issue only appeared after I added nearly a thousand items to the shop. I wonder if theres a way that an index could be utilized for improvements on page load? Since the full scan causes a performance hit on my forum. Just spitballing.

Can you show me a screenshot of the query in the debug view, including the full stack trace (in a separate screenshot if necessary)?

I have a suspicion of what might be the cause, but with the above info I'll be able to tell for certain