Page 1 of 1

slow prediction ranking

Posted: Tue Jun 19, 2012 3:37 pm
by Becks
diddipoeler wrote:
Becks wrote:When this module is enabled the loading of site going too long. When I switch it off the site load faster.

da muss ich noch etwas an der performance basteln !


I noticed that the problem comes from prediction game ranking. I have over 400 active users and when I go to ranking site loading very slow, but when I go to do tips page its OK.

Re: Modul Top Tipper

Posted: Tue Jun 19, 2012 4:12 pm
by diddipoeler
Becks wrote:
diddipoeler wrote:
Becks wrote:When this module is enabled the loading of site going too long. When I switch it off the site load faster.

da muss ich noch etwas an der performance basteln !

I noticed that the problem comes from prediction game ranking. I have over 400 active users and when I go to ranking site loading very slow, but when I go to do tips page its OK.

aha, das ist schon mal ein heisser tip ;)
entweder sind die datenbank abfragen nicht richtig programmiert oder es fehlt ein wichtiger index.
hast du wirklich 400 user in einem tippspiel ?
da muss ernatürlich eine menge sortieren, ne wa ?

Re: Modul Top Tipper

Posted: Tue Jun 19, 2012 4:18 pm
by Becks
check here: http://www.premierleaguebg.com/standings

this is ranking where are my users :) and not all because there is not page navigation

Re: Modul Top Tipper

Posted: Tue Jun 19, 2012 9:18 pm
by timoline
looks nice becks.........pagination is still a feature request......you have to wait till diddi is back :)
But good to see it works.....prediction ext. can use some work though

Re: Modul Top Tipper

Posted: Tue Jun 19, 2012 9:29 pm
by Becks
timoline wrote:looks nice becks.........pagination is still a feature request......you have to wait till diddi is back :)
But good to see it works.....prediction ext. can use some work though



I have patience to wait ;) I've waited for so much time :)

Re: Modul Top Tipper

Posted: Wed Jun 20, 2012 1:56 pm
by diddipoeler
Becks wrote:
timoline wrote:looks nice becks.........pagination is still a feature request......you have to wait till diddi is back :)
But good to see it works.....prediction ext. can use some work though

I have patience to wait ;) I've waited for so much time :)

dein betteln und quängeln habe ich erhört, weil du ja schon so lange wartest.
dann lad dir mal hier: http://**************.grammatikas-gri ... info&id=22 die neue version herunter.

sie beinhaltet eine abgeänderte pagination-version der standardpagination von joomla.

Re: Modul Top Tipper

Posted: Wed Jun 20, 2012 5:48 pm
by Becks
Thank you Diddi now looks fantastic :)

Re: slow prediction ranking

Posted: Wed Jun 20, 2012 7:05 pm
by timoline
I noticed when I set to show 15 on 1 page, there are 179 pages......go to page 179 or 178 or 160...., they are all empty, so i think thats a small bug :confused: (pagination total)

I also noticed on you pred ranking view that the ranking numbers or incorrect, or am I wrong?

1
2
3
3
4
4
5
5
6
7

shouldnt that be

1
2
3
.-
5
.-
6
.-
7
8

Frontend Bug #1480

Re: slow prediction ranking

Posted: Wed Jun 20, 2012 10:37 pm
by diddipoeler
timoline wrote:I noticed when I set to show 15 on 1 page, there are 179 pages......go to page 179 or 178 or 160...., they are all empty, so i think thats a small bug :confused: (pagination total)

Haeh :confused:
Du hast über 2800 Tipper ?

Re: slow prediction ranking

Posted: Thu Jun 21, 2012 10:26 am
by diddipoeler
timoline wrote:I noticed when I set to show 15 on 1 page, there are 179 pages......go to page 179 or 178 or 160...., they are all empty, so i think thats a small bug :confused: (pagination total)

lade dir mal bitte die neue version bei mir herunter !

Re: slow prediction ranking

Posted: Thu Jun 21, 2012 9:48 pm
by Becks
Yes diddi I assign all my registered user in prediction game thats why I have more than 2800 users. When you do some changes just let me know and I will update ;)

Re: slow prediction ranking

Posted: Fri Jun 22, 2012 9:44 am
by diddipoeler
Becks wrote:Yes diddi I assign all my registered user in prediction game thats why I have more than 2800 users. When you do some changes just let me know and I will update ;)

Mach mal bitte ein Update.

Re: slow prediction ranking

Posted: Fri Jun 22, 2012 11:19 am
by Becks
diddipoeler wrote:Mach mal bitte ein Update.


Done

Re: slow prediction ranking

Posted: Fri Jun 22, 2012 4:30 pm
by timoline
so you assigned all your users, thats about 54 pages, I only see 7 pages with "active" pred users, thats a lot unneeded overhead (unneeded db usage), thats making it much slower ofcourse

Re: slow prediction ranking

Posted: Fri Jun 22, 2012 5:10 pm
by Becks
timoline wrote:so you assigned all your users, thats about 54 pages, I only see 7 pages with "active" pred users, thats a lot unneeded overhead (unneeded db usage), thats making it much slower ofcourse


You were right and I deleted all inactive users. Now load much faster. Thanks for the advice, but this should be a something to think about for the feature if someone have prediction game with more users :)