Announcement

  •  » Engine
  •  » improving average rate and sort order on best rated page

#16 2011-07-22 16:12:38

flop25
Piwigo Team
2006-07-06
7037

Re: improving average rate and sort order on best rated page

rvelices wrote:

The popularity score might be difficult to compute and maintain in php/mySql (the rating score alone appears more complicated ...). But on the long run why not have "Best rated" and "Most popular" if we come up with a solution scalable  for large dbs ?

with the method used in the wp plugin, it seems easy and not for large db : just the taking into account this new rating score, the date of insertion -file creation i think? I don't remember which one is what-, number of comments and num of views -maybe also how much user can access-.
The problem will be the update... when we should update a popularity score ? Ideally on each view, comments and rating !

We will discuss about that later and in another thread, when the score rating will be implemented.

About the rating score, when you say

Let's start with no time effect, no permission effect... We'll see later

, I don't agree : rating score should be calculated only with the ratings.


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#17 2011-07-22 16:30:27

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13848

Re: improving average rate and sort order on best rated page

flop25 wrote:

About the rating score, when you say

Let's start with no time effect, no permission effect... We'll see later

, I don't agree : rating score should be calculated only with the ratings.

I don't see where you disagree with rvelices

Offline

 

#18 2011-07-22 16:37:34

flop25
Piwigo Team
2006-07-06
7037

Re: improving average rate and sort order on best rated page

plg wrote:

flop25 wrote:

About the rating score, when you say

Let's start with no time effect, no permission effect... We'll see later

, I don't agree : rating score should be calculated only with the ratings.

I don't see where you disagree with rvelices

"we'll see later" imply it will be study later on for implementation ; I just say "we'll never see" or "we'll see later but not for rating score"


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#19 2011-07-22 16:43:24

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13848

Re: improving average rate and sort order on best rated page

I agree with rvelices, we'll see later.

Offline

 

#20 2011-07-25 13:38:53

rvelices
Former Piwigo Team
2005-12-29
1960

Re: improving average rate and sort order on best rated page

I have an almost finalized version.

It's ok for you if I backport to 2.2? With or without language keys changed ?

Should we display on the picture page the average rate in addition to rating score and number of rates ?

Offline

 

#21 2011-07-25 13:43:19

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13848

Re: improving average rate and sort order on best rated page

Very good news! I admit that I'm impatient to see the result :-)

No, don't backport on 2.2. This is a 2.3 feature (but I can backport it on piwigo.org/showcase).

Visitors won't understand what's the difference between "rating score" and "average rate" so I would only display "rating score" with a tooltip like "rating score includes the ratings this photo received and the number of rates but is not the average rate"

Offline

 

#22 2011-07-25 13:45:35

flop25
Piwigo Team
2006-07-06
7037

Re: improving average rate and sort order on best rated page

plg wrote:

Visitors won't understand what's the difference between "rating score" and "average rate" so I would only display "rating score" with a tooltip like "rating score includes the ratings this photo received and the number of votes but is not the average rate"

+1


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#23 2011-07-29 10:14:07

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13848

Re: improving average rate and sort order on best rated page

rvelices, no database column rename? (I'm testing the feature on my local copy before preparing 2.3.0beta3)

Offline

 

#24 2011-07-29 14:58:10

rvelices
Former Piwigo Team
2005-12-29
1960

Re: improving average rate and sort order on best rated page

plg wrote:

rvelices, no database column rename? (I'm testing the feature on my local copy before preparing 2.3.0beta3)

not yet because of sqlite. Certainly i wont spend time on this.
It's not the right place for the discussion but I think supporting something else than mysql is not a good idea. nobody does (wp, gallery3 etc...). it's used probably by 0.5% of users and it's a pain in writing optimized queries db upgrades etc...

so I will do it but nothing for sqlite if you are ok.

Offline

 

#25 2011-07-29 15:43:04

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13848

Re: improving average rate and sort order on best rated page

rvelices wrote:

It's not the right place for the discussion but I think supporting something else than mysql is not a good idea. nobody does (wp, gallery3 etc...). it's used probably by 0.5% of users and it's a pain in writing optimized queries db upgrades etc...

You're right, it's not the right place, but it's a very important topic. Please open another discussion in the forum.

rvelices wrote:

so I will do it but nothing for sqlite if you are ok.

than means there is no upgrade possible for SQLite users. Considering that SQLite is still marked as experimental I would say that it's OK.

Offline

 

#26 2011-07-29 17:23:49

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13848

Re: improving average rate and sort order on best rated page

In my local gallery, I have some photos with rating 5+5 and they have a higher rating score than photos rated only once with a 5 => perfect !

Offline

 
  •  » Engine
  •  » improving average rate and sort order on best rated page

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact