slow prediction ranking

This Extension is Freeware and is available in our Extensions directory.
Becks
.
Posts: 87
Joined: Wed May 07, 2008 5:33 pm
Contact:

slow prediction ranking

Postby Becks » Tue Jun 19, 2012 3:37 pm

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.
Joomla 2.5.11
JoomLeague - v2.0.84.f90c771
http://www.premierleaguebg.com

User avatar
diddipoeler
.
Posts: 1152
Joined: Sun Feb 04, 2007 3:29 pm
Joomleague version: 2.0.x
Contact:

Re: Modul Top Tipper

Postby diddipoeler » Tue Jun 19, 2012 4:12 pm

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 ?
über 8 Mio. Spielpaarungen auf http://www.laola-fussball-international.de/
über 8 Mio. Spielpaarungen auf http://www.**************.de/
Joomlaversion: 1.5.26
Testserver mit Joomleague Version 0.93
Tippspieltestseite: http://joomleague16.**************/
Das Komplettpaket: https://github.com/diddipoeler/joomleague-komplett
Das Komplettpaket 2.0: https://github.com/diddipoeler/joomleague-2-komplettpaket

Becks
.
Posts: 87
Joined: Wed May 07, 2008 5:33 pm
Contact:

Re: Modul Top Tipper

Postby Becks » Tue Jun 19, 2012 4:18 pm

check here: http://www.premierleaguebg.com/standings

this is ranking where are my users :) and not all because there is not page navigation
Joomla 2.5.11
JoomLeague - v2.0.84.f90c771
http://www.premierleaguebg.com

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: Modul Top Tipper

Postby timoline » Tue Jun 19, 2012 9:18 pm

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
Joomla 1.5.x
Joomleague 1.5.....latest git version

Becks
.
Posts: 87
Joined: Wed May 07, 2008 5:33 pm
Contact:

Re: Modul Top Tipper

Postby Becks » Tue Jun 19, 2012 9:29 pm

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 :)
Joomla 2.5.11
JoomLeague - v2.0.84.f90c771
http://www.premierleaguebg.com

User avatar
diddipoeler
.
Posts: 1152
Joined: Sun Feb 04, 2007 3:29 pm
Joomleague version: 2.0.x
Contact:

Re: Modul Top Tipper

Postby diddipoeler » Wed Jun 20, 2012 1:56 pm

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.
über 8 Mio. Spielpaarungen auf http://www.laola-fussball-international.de/
über 8 Mio. Spielpaarungen auf http://www.**************.de/
Joomlaversion: 1.5.26
Testserver mit Joomleague Version 0.93
Tippspieltestseite: http://joomleague16.**************/
Das Komplettpaket: https://github.com/diddipoeler/joomleague-komplett
Das Komplettpaket 2.0: https://github.com/diddipoeler/joomleague-2-komplettpaket

Becks
.
Posts: 87
Joined: Wed May 07, 2008 5:33 pm
Contact:

Re: Modul Top Tipper

Postby Becks » Wed Jun 20, 2012 5:48 pm

Thank you Diddi now looks fantastic :)
Joomla 2.5.11
JoomLeague - v2.0.84.f90c771
http://www.premierleaguebg.com

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: slow prediction ranking

Postby timoline » Wed Jun 20, 2012 7:05 pm

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
Joomla 1.5.x
Joomleague 1.5.....latest git version

User avatar
diddipoeler
.
Posts: 1152
Joined: Sun Feb 04, 2007 3:29 pm
Joomleague version: 2.0.x
Contact:

Re: slow prediction ranking

Postby diddipoeler » Wed Jun 20, 2012 10:37 pm

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 ?
über 8 Mio. Spielpaarungen auf http://www.laola-fussball-international.de/
über 8 Mio. Spielpaarungen auf http://www.**************.de/
Joomlaversion: 1.5.26
Testserver mit Joomleague Version 0.93
Tippspieltestseite: http://joomleague16.**************/
Das Komplettpaket: https://github.com/diddipoeler/joomleague-komplett
Das Komplettpaket 2.0: https://github.com/diddipoeler/joomleague-2-komplettpaket

User avatar
diddipoeler
.
Posts: 1152
Joined: Sun Feb 04, 2007 3:29 pm
Joomleague version: 2.0.x
Contact:

Re: slow prediction ranking

Postby diddipoeler » Thu Jun 21, 2012 10:26 am

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 !
über 8 Mio. Spielpaarungen auf http://www.laola-fussball-international.de/
über 8 Mio. Spielpaarungen auf http://www.**************.de/
Joomlaversion: 1.5.26
Testserver mit Joomleague Version 0.93
Tippspieltestseite: http://joomleague16.**************/
Das Komplettpaket: https://github.com/diddipoeler/joomleague-komplett
Das Komplettpaket 2.0: https://github.com/diddipoeler/joomleague-2-komplettpaket

Becks
.
Posts: 87
Joined: Wed May 07, 2008 5:33 pm
Contact:

Re: slow prediction ranking

Postby Becks » Thu Jun 21, 2012 9:48 pm

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 ;)
Joomla 2.5.11
JoomLeague - v2.0.84.f90c771
http://www.premierleaguebg.com

User avatar
diddipoeler
.
Posts: 1152
Joined: Sun Feb 04, 2007 3:29 pm
Joomleague version: 2.0.x
Contact:

Re: slow prediction ranking

Postby diddipoeler » Fri Jun 22, 2012 9:44 am

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.
über 8 Mio. Spielpaarungen auf http://www.laola-fussball-international.de/
über 8 Mio. Spielpaarungen auf http://www.**************.de/
Joomlaversion: 1.5.26
Testserver mit Joomleague Version 0.93
Tippspieltestseite: http://joomleague16.**************/
Das Komplettpaket: https://github.com/diddipoeler/joomleague-komplett
Das Komplettpaket 2.0: https://github.com/diddipoeler/joomleague-2-komplettpaket

Becks
.
Posts: 87
Joined: Wed May 07, 2008 5:33 pm
Contact:

Re: slow prediction ranking

Postby Becks » Fri Jun 22, 2012 11:19 am

diddipoeler wrote:Mach mal bitte ein Update.


Done
Joomla 2.5.11
JoomLeague - v2.0.84.f90c771
http://www.premierleaguebg.com

User avatar
timoline
Joomleague Core Developer, Donator
Joomleague Core Developer, Donator
Posts: 3331
Joined: Thu Mar 12, 2009 8:03 am
Contact:

Re: slow prediction ranking

Postby timoline » Fri Jun 22, 2012 4:30 pm

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
Joomla 1.5.x
Joomleague 1.5.....latest git version

Becks
.
Posts: 87
Joined: Wed May 07, 2008 5:33 pm
Contact:

Re: slow prediction ranking

Postby Becks » Fri Jun 22, 2012 5:10 pm

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 :)
Joomla 2.5.11
JoomLeague - v2.0.84.f90c771
http://www.premierleaguebg.com


Return to “Predictiongame / Tipspiel”

Who is online

Users browsing this forum: No registered users and 2 guests

cron