Disable Hits item record?

Hi!
I know, that when user opens any item on site - FC (and Joomla) stores in DB table com_content HIts counter.
So, if site have very big traffic - this is a very slow site speed.

Is it possible to disable this?

Also question: what else FC stores in DB on each user visit on item page.
Thanks.

Hello

yes the DB updates are much more of a concern than SELECTs
AND IF you use MyISAM then an update locks the full content TABLE ... which may slow down your website
- if you are using innoDB then you have no such problem (and J3 does work with innoDB properly)

- also selects can be cached by your DB server in short periods
- plus you can enable Joomla caching to avoid most of them completely
- and we have done a lot of work to avoid optimize SELECT queries that could have been expensive

----

About DB table "updates / inserts"
- yes, we only update the content / category view tables with the hits counter

but we do this even when view caching and page cache plugin
and joomla also did same thing in J3.5+ making hits work even when caching is ON

----

Now if you have access to MySQL configuration ... some VPS are "sharing" the DB server and will not allow you to change MySQL config then you can do more optimizations, read more here:


Updating the Hits Counter on Your Joomla Website Taking a Long Time? Read This!

Hello

also another one:
haydenjames.io/mysql-query-cache-size-performance/

ggppdk wrote: Hello

yes the DB updates are much more of a concern than SELECTs
AND IF you use MyISAM then an update locks the full content TABLE ... which may slow down your website
- if you are using innoDB then you have no such problem (and J3 does work with innoDB properly)

Ok, my server supports both InnoDB and MyISAM. Should I do anything about this?

Hello

check that tables
#__content
#__category

are innodb

and also you may check that your MySQL cache is no more than 100 MBytes