Raised This Month: $12 Target: $400
 3% 

Release Beta Webpanel 1.2.5 (improved loading times)


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Arrow768
Veteran Member
Join Date: Nov 2011
Location: Austria
Old 04-28-2014 , 16:16   Beta Webpanel 1.2.5 (improved loading times)
Reply With Quote #1

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)
__________________
Arrow768 is offline
Bubka3
Sir Buzz Killington, Esq.
Join Date: Jan 2010
Location: New York, NY
Old 04-28-2014 , 16:46   Re: Beta Webpanel 1.2.5 (improved loading times)
Reply With Quote #2

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.

Last edited by Bubka3; 04-28-2014 at 16:56.
Bubka3 is offline
Arrow768
Veteran Member
Join Date: Nov 2011
Location: Austria
Old 04-28-2014 , 17:30   Re: Beta Webpanel 1.2.5 (improved loading times)
Reply With Quote #3

Quote:
Originally Posted by Bubka3 View Post
[...]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.
Quote:
Originally Posted by Arrow768 View Post
If you have got problems with the loading times, please post in this thread and I will send you a link to the beta.
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").
__________________

Last edited by Arrow768; 05-02-2014 at 03:37.
Arrow768 is offline
Arrow768
Veteran Member
Join Date: Nov 2011
Location: Austria
Old 04-30-2014 , 06:24   Re: Beta Webpanel 1.2.5 (improved loading times)
Reply With Quote #4

Only the latest development version of the store plugin is officially supported.
__________________
Arrow768 is offline
Arrow768
Veteran Member
Join Date: Nov 2011
Location: Austria
Old 04-30-2014 , 14:46   Re: Beta Webpanel 1.2.5 (improved loading times)
Reply With Quote #5

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)
__________________

Last edited by Arrow768; 04-30-2014 at 14:57.
Arrow768 is offline
vodka00
Veteran Member
Join Date: Jun 2012
Location: Los Angeles
Old 04-30-2014 , 18:48   Re: Beta Webpanel 1.2.5 (improved loading times)
Reply With Quote #6

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

cw speedruns:
vodka00 is offline
Bubka3
Sir Buzz Killington, Esq.
Join Date: Jan 2010
Location: New York, NY
Old 05-02-2014 , 12:32   Re: Beta Webpanel 1.2.5 (improved loading times)
Reply With Quote #7

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.
Bubka3 is offline
Arrow768
Veteran Member
Join Date: Nov 2011
Location: Austria
Old 05-03-2014 , 05:52   Re: Beta Webpanel 1.2.5 (improved loading times)
Reply With Quote #8

Quote:
Originally Posted by Bubka3 View Post
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.
Thats already solved (I forgot to send you the new version)

Quote:
Originally Posted by Bubka3 View Post
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
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.
__________________
Arrow768 is offline
aaron1234
Member
Join Date: Feb 2012
Old 05-03-2014 , 19:05   Re: Beta Webpanel 1.2.5 (improved loading times)
Reply With Quote #9

Quote:
Originally Posted by Arrow768 View Post
Only the latest development version of the store plugin is officially supported.
where can you find the latest development version? because all I can find is 1.1-alpha.
aaron1234 is offline
Arrow768
Veteran Member
Join Date: Nov 2011
Location: Austria
Old 05-03-2014 , 20:37   Re: Beta Webpanel 1.2.5 (improved loading times)
Reply With Quote #10

https://github.com/alongubkin/store/tree/development
__________________
Arrow768 is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:28.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode