Re: optimized counting of web statistics

Поиск
Список
Период
Сортировка
От Billy extyeightysix
Тема Re: optimized counting of web statistics
Дата
Msg-id 22455e7050628134348a74d7c@mail.gmail.com
обсуждение исходный текст
Ответ на optimized counting of web statistics  (Billy extyeightysix <exty86@gmail.com>)
Список pgsql-performance
> The bottleneck in the
> whole process is actually counting each data point (how many times a
> url was visited, or how many times a url referred the user to the
> website). So more specifically I am wondering if there is way to store
> and retrieve the data such that it speeds up the counting of the
> statistics.

This is misleading, the counting is being done by perl.  so what is
happening is that I am locating all of the rows via a cursor and then
calculating the stats using perl hashes.  no counting is being in the
DB.  maybe it would be much faster to count in the db somehow?


exty

В списке pgsql-performance по дате отправления:

Предыдущее
От: Billy extyeightysix
Дата:
Сообщение: optimized counting of web statistics
Следующее
От: Matthew Nuzum
Дата:
Сообщение: Re: optimized counting of web statistics