I want to count visits on a web page, and this page is an element of my model, as well as pageviews of the stack overflow question.
How to do it in reliable (one visit, one page view, without repetitions) and reliable (thinking about performance, not just the new attribute of the visit_count table)
You can not.
, , IP- , . , cookie, . IP-, , - .
- , - , .
, , Google Analytics. , , , , .
4 000 000 .
http://www.google.com/analytics
- . -
UPDATE stat SET viewcount = viewcount+1 WHERE date = CURDATE()
, .
- . cookie, , cookie ..
Source: https://habr.com/ru/post/1703365/More articles:How to write a "tagging" query in SQL? - sqlWhat is the best way to update a single record through SQL and get the ID of the updated record? (Java / MSSQL) - javaBest Place for a Reusable Helper Method in Rails 2.2 - ruby | fooobar.comPassing a JSP stream to a method - javaВыберите элемент, в котором есть другой элемент внутри - xpathIs it bad practice for an object to catch its own exception and keep the message in the property? - oopfull-text index not updating (SQL 2005) - sqlHow can a servlet get the absolute path to a file outside the servlet? - javahttps://translate.googleusercontent.com/translate_c?depth=1&pto=aue&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=https://fooobar.com/questions/1703369/is-there-a-physical-limit-in-windows-to-the-number-of-usb-drives-that-can-be-mounted&usg=ALkJrhjs3C9y-eSBkSG1bzUhddgB7CN9UgDoes PostgreSQL support the constant use of its pl * interpreters? - perlAll Articles