Fix the seller dashboard

[BGHDDevelopment]

Something needs to be done about the seller dashboard. At this point, I am unable to even load the page. I have heard this is because it's not cached like the rest of the site, and due to the large number of licenses from my account. While this may be true, I would suggest something is done to fix it, this could be caching older pages and just make the new pages non-cached. You could also only load a page of licenses each time and then load them when the next page is hit so they don't load all at once.
Right now it's impossible to track purchases or even manually add/remove licenses.

This has been an issue for a very long time and it should be fixed.

 

[FaceSlap_]

I am facing the same issue here, well for me it does load but very very slow.

 

[Ghast]

Same issue here. Does not load at all.

 

[MarkElf]

Has been an issue for over a year, I know as I made a thread with the same topic as did several other resource owners. If I recall correctly, they said they were going to fix it (last?) summer and I've yet to notice a change.

 

[BGHDDevelopment]

Just going to bump this, this is a continuing issue and so far no word on a solution.

 

[Jayson]

I have heard this is because it's not cached like the rest of the site, and due to the large number of licenses from my account. While this may be true, I would suggest something is done to fix it, this could be caching older pages and just make the new pages non-cached. You could also only load a page of licenses each time and then load them when the next page is hit so they don't load all at once.

Nothing to do with caching for the most part because they're all fetched on request so that the data is always accurate. We also already paginate it. The issue is because the add-on's original author made the queries extremely inefficient, thereby making it take too long to where Cloudflare kicks out.

I managed to strip out some parts. Please check your resource dashboard and let me know if it still errors out and verify that the data is correct. As of the latest announcement, we do not have any large resource authors in the staff team, so unfortunately I can't quite check it myself. Do note that I did not really care about avatars when stripping out data.

 

[CustomEnchants]

Nothing to do with caching for the most part because they're all fetched on request so that the data is always accurate. We also already paginate it. The issue is because the add-on's original author made the queries extremely inefficient, thereby making it take too long to where Cloudflare kicks out.

I managed to strip out some parts. Please check your resource dashboard and let me know if it still errors out and verify that the data is correct. As of the latest announcement, we do not have any large resource authors in the staff team, so unfortunately I can't quite check it myself. Do note that I did not really care about avatars when stripping out data.

Viewing up a license of a induvidual user is completly broken when searching for a specific user then clicking on all

 

[Jayson]

Viewing up a license of a induvidual user is completly broken when searching for a specific user then clicking on all

Please try again I was adjusting it some more to fix a bad non-critical index error for authors using the license per URL feature. You probably got caught in between the refresh.

 

[BGHDDevelopment]

Nothing to do with caching for the most part because they're all fetched on request so that the data is always accurate. We also already paginate it. The issue is because the add-on's original author made the queries extremely inefficient, thereby making it take too long to where Cloudflare kicks out.

I managed to strip out some parts. Please check your resource dashboard and let me know if it still errors out and verify that the data is correct. As of the latest announcement, we do not have any large resource authors in the staff team, so unfortunately I can't quite check it myself. Do note that I did not really care about avatars when stripping out data.

Just tested and while the loading is still slow(30-50sec) it does load the page now and I can edit licenses as normal. Thanks for all your hardwork!

 

[Ome_R]

There seems to be an issue with the "your last sales" - it prints my name instead of the actual customer's name
Besides that, the loading times are still slow, but at least there's no timeout.
Searching resources for a specific player (aka with a filter) seems to work just fine.

Thanks for fixing it [DOUBLEPOST=1594651610][/DOUBLEPOST]

Nothing to do with caching for the most part because they're all fetched on request so that the data is always accurate. We also already paginate it. The issue is because the add-on's original author made the queries extremely inefficient, thereby making it take too long to where Cloudflare kicks out.

I managed to strip out some parts. Please check your resource dashboard and let me know if it still errors out and verify that the data is correct. As of the latest announcement, we do not have any large resource authors in the staff team, so unfortunately I can't quite check it myself. Do note that I did not really care about avatars when stripping out data.

I am willing to also help with that if you need someone with large amount of customers

 

[Jayson]

In effort to reduce load times, I have also reduced the amount of entries shown per page by 5 to 10. Any issues addressed in the thread will be worked on in an hour or two as I fetch something to eat.

 

[Ome_R]

In effort to reduce load times, I have also reduced the amount of entries shown per page by 5 to 10. Any issues addressed in the thread will be worked on in an hour or two as I fetch something to eat.

I might be wrong, but it doesn't seem to change the loading times

 

[Jayson]

I might be wrong, but it doesn't seem to change the loading times

Mind providing me details on specifically which pages are sluggish (more than 10 seconds)?

 

[MarkElf]

I was finally able to open the manage licenses page. It does take a moment (~26s) to load but does load none the less.

 

[Jayson]

I was finally able to open the manage licenses page. It does take a moment (~26s) to load but does load none the less.

Mind providing me details on specifically which pages are sluggish (more than 10 seconds)?

I have a fix, but I don't want to apply it to pages that I don't need to because it uses slightly more memory. Please answer. :^)

Edit: Now applying changes. Dashboard might go down for a few minutes.[DOUBLEPOST=1594657220][/DOUBLEPOST]Ome_R / MarkElf / BGHDDevelopment, it should take about 2 seconds to load the page now. Mind checking for me?

 

[BGHDDevelopment]

Much faster on the first load of the page (for license manager), still slow when switching pages on the license manager section. Another thing I noticed is on the left the latest sales are all sales from like 2017 rather than the lastest sales from like yesterday. I think it's listing your first sales rather than the latest.

 

[Jayson]

Another thing I noticed is on the left the latest sales are all sales from like 2017 rather than the lastest sales from like yesterday. I think it's listing your first sales rather than the latest.

Thanks. I'll try and have that fixed tonight.

Update: If all works out, it’ll be implemented the morning of the 14th.

 

[MarkElf]

It's pretty usable. ~5 seconds to load between pages of 'manage licenses' which isn't the end of the world. Searching is good. Thank you for finally addressing this Jayson!

 

[Jayson]

Making adjustments to fix ordering. The seller dashboard may be intermittently down for the next hour or so, but it should barely affect anyone. Will update when completed.

Update 18 July 2020 17:01:47: Actually going to take a quick lunch break. Resuming after I'm done. I'm sorry for being a mortal.

Update 18 July 2020 17:08:14: Actually getting back to it.

Delayed for development of a related item.

 

[Ome_R]

Jayson Hey, not sure if you are aware but "Your last sales" under the seller dashboard is still not showing the correct data.