Basic usage statistics

[Leonel Câmara]

Minor implementation details aside, has anyone came up with a better way to do this?

http://www.web2pyslices.com/slice/show/1618/basic-usage-statistics-log-what-your-users-do

Particularly, in terms of not hitting the database so much. I'm thinking of making my own system but I may as well ask before reinventing the wheel.

[Richard Vézina]

You may consider, log in memory and write once you have an hundred records with scheduler...

This could be a great improve and a better log system on that matter... So far, with more then an hundred user, it never been an issue...

Richard

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Richard Vézina]

I am not sure though that this is possible, I mean, is there a way to db.table.insert() without db.commit() even if other change are commited... Or say differently, is possible to specifically commit db operation?? You may also just remove the db.commit() and insert will be commited the next time db.commit() will be call. I never try this...

Richard

[Richard Vézina]

Also Leonel, if you have an app that really requires more then that (I mean not an in house intranet app) you may consider Piwik : http://piwik.org/

Richard

[Derek]

Google has, it's called Google Analytics. There are alternatives out there. You could also use your web server log files.

[Richard Vézina]

For LAN Piwik!!

Richard

--

[Niphlod]

you could use a redis queue to push events into, and then a scheduler tasks that consolidates the data in a table once in a while. 

[Richard Vézina]

Not sure how you can know which user access what without using my usage statistics stuff... With Piwik or Google Analytic you will rely on IP address? I use Google Analytic a little long time ago...

Richard

--

[Leonel Câmara]

Exactly Richard, I would like to know which users are accessing what, because the users like to see it. The redis solution may be the best one if I want to give the database a break.

[Richard Vézina]

Yes, Simone proposition is really good...

Richard

On Thu, Jun 11, 2015 at 4:20 PM, Leonel Câmara <leonel...@gmail.com> wrote:

Exactly Richard, I would like to know which users are accessing what, because the users like to see it. The redis solution may be the best one if I want to give the database a break.

--