Beta Webpanel 1.2.5 (improved loading times)
 

Currently I have got a beta version of the WebPanel 1.2.5 with improved loading times at the users page
(A DB with more then 5000 Users loads now in ~260 ms on a avg host; the actual query takes ~30ms).

If you have got problems with the loading times, please post in this thread and I will send you a link to the beta.

(Its a beta because its a quick implementation (copy and paste with small changes) of something I plan to add in the upcoming 1.2.5 release)

Re: Beta Webpanel 1.2.5 (improved loading times)
 

I've wondered why you load all the items (at least in the items page) instead of using built in code-igniter pagination options. It seems silly to load all the items at once and only show 10 at a time. Just load 10 and load 10 more when the user request the next page.

Unless you changed it in this release. Then never mind.

EDIT: Where is this release?
https://github.com/Arrow768/store-webpanel/releases

I also checked both of the branches but the last commits were at least 4 months ago.

Re: Beta Webpanel 1.2.5 (improved loading times)
 

I am sending it via pm, cause currently its just a very dirty implementation of datatables serverside processing.

I would like to clean up the code and move some stuff to CI Functions before commiting it to the public repo.



When I wrote the user page the first time I didnt know that CI has got a inbuild pagination option.

Then I added the datatables to the userpage to get the option to search and sort without reloading the page (but I had to load all the users in advance) and tested the performance on my homeserver (It has got a local SSD Cache so I am getting a very good performance, the problem was that I have not thought of the real-world scenario where a lot of db servers are running on slow hardware).

Now I have "implemented" the datatables serverside processing. It only load the items that are displayed (so if you have selected 10 users, its just loading 10 users).

But I had to remove the column that shows the number of items a user has got in his inventory.
The old implementaiton with the user-item-count used n+1 querys to query n users.
(On my test server that was not a huge problem, cause the db is cached on the ssd, its in my lan and I have tested it with a few 1000 "users").

Re: Beta Webpanel 1.2.5 (improved loading times)
 

Only the latest development version of the store plugin is officially supported.

Re: Beta Webpanel 1.2.5 (improved loading times)
 

I managed to add the user item count again.
But you cant sort or search this column (It would take too much time to get the user item count for all users in the db)

Re: Beta Webpanel 1.2.5 (improved loading times)
 

This works really well, I haven't had any issues yet. Thank you for your work Arrow.

Re: Beta Webpanel 1.2.5 (improved loading times)
 

Patch is interesting.

The the users page, nothing is clickable (id, etc) so you can't access the user w/o manually entering the URL.

The add an item to a user page, needs to stop loading all items. Put in a search bar and load items on search to add. Include the item category to allow for easy access to items named the same but in different categories.

Re: Beta Webpanel 1.2.5 (improved loading times)
 

Thats already solved (I forgot to send you the new version)

Thats a good idea, I am going to add that in a upcoming version


I am going to commit the patch to the github repo in the next days.

Re: Beta Webpanel 1.2.5 (improved loading times)
 

where can you find the latest development version? because all I can find is 1.1-alpha.

Re: Beta Webpanel 1.2.5 (improved loading times)