[support] Counting the number of node created by user, Views only

[Lluís Forns]

Right now I work with large databases, so to make count() and sum() I
have to calculate all the data using a batch and then list it using
views. But for small databases and simple queries, it isn't necessary.

2010/12/22 Victor Kane <victorkane at gmail.com>:
> He's counting, there are no results to count
>
> On Wed, Dec 22, 2010 at 3:48 PM, Lluís Forns <enboig at gmail.com> wrote:
>>
>> Suppose you want to make a "ranking" of contributors, being able to
>> sort them. search by name, etc...
>>
>> I think the best way is using Views GroupBy  module, using PHP won't
>> allow you to sort the results.
>>
>> If performance is important, you could cache the results in a table
>> using cron and just show them when needed.
>>
>> 2010/12/22 Pierre Rineau <pierre.rineau at makina-corpus.com>:
>> > Le mercredi 22 décembre 2010 à 09:23 +0100, Denis Lafont-Trevisan a
>> > écrit :
>> >> Hi,
>> >>
>> >>
>> >> Sounds stupid but I can't manage to create a view that count the
>> >> number of node of a certain type each user created.
>> >
>> > What are you really trying to do? This sounds quite stupid to use views
>> > only to count something. Are you really willing to consume 10M of memory
>> > and 100ms of execution time to only do a COUNT query?
>> >
>> > Pierre.
>> >
>> >
>> > --
>> > [ Drupal support list | http://lists.drupal.org/ ]
>>
>>
>>
>> --
>> *Les normes hi són perquè hi pensis abans de saltar-te-les
>> *La vida és com una taronja, què esperes a exprimir-la?
>> *Si creus que l'educació és cara, prova la ignorància.
>> *La vida és com una moneda, la pots gastar en el que vulguis però
>> només una vegada.
>> *Abans d'imprimir aquest missatge, pensa en el medi ambient.
>> --
>> [ Drupal support list | http://lists.drupal.org/ ]
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>



-- 
*Les normes hi són perquè hi pensis abans de saltar-te-les
*La vida és com una taronja, què esperes a exprimir-la?
*Si creus que l'educació és cara, prova la ignorància.
*La vida és com una moneda, la pots gastar en el que vulguis però
només una vegada.
*Abans d'imprimir aquest missatge, pensa en el medi ambient.