I'm pretty sure it's not, but is the counter_history data used for anything other than populating the Visitor table in admin?
Thread: Counter_history
Results 1 to 6 of 6
-
9 Dec 2020, 06:14 PM #1
Totally Zenned
- Join Date
- Oct 2004
- Location
- Southport, UK
- Posts
- 4,237
- Plugin Contributions
- 20
Counter_history
Development Manager @ JSWeb Ltd
Over 15 years with Zencart
-
Re: Counter_history
No, that's all. Just the visits/sessions table/graph.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
9 Dec 2020, 07:38 PM #3
Totally Zenned
- Join Date
- Oct 2004
- Location
- Southport, UK
- Posts
- 4,237
- Plugin Contributions
- 20
Re: Counter_history
Excellent. Thanks.
We had 6 or 7 long-established clients where this table grew to 500,000+ records, and whilst I don't personally understand why, the sites all slowed down considerably...clearing out this table restored all off them to normal, so it must be more than a coincidence.
Just wanted to be sure that the Visitor History was the only thing affected.Development Manager @ JSWeb Ltd
Over 15 years with Zencart
-
Re: Counter_history
Any chance you have a backup of one of those that we could do some testing against? I wonder if an index might help, or whether switching it to InnoDB might help?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
9 Dec 2020, 10:14 PM #5
Totally Zenned
- Join Date
- Oct 2004
- Location
- Southport, UK
- Posts
- 4,237
- Plugin Contributions
- 20
Re: Counter_history
I'll send it via a private message
Development Manager @ JSWeb Ltd
Over 15 years with Zencart
-
10 Dec 2020, 02:00 PM #6
Totally Zenned
- Join Date
- Jul 2012
- Posts
- 16,734
- Plugin Contributions
- 17
Re: Counter_history
For other readers, note that attachment of the file actually can't be done via PM; however, I'm sure that the above worked out how to get the right information to the right place. :)
Originally Posted by Ryk
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
Reply With Quote
Similar Threads
-
1194 Table 'counter_history' is marked as crashed
By malejyetti in forum General QuestionsReplies: 6Last Post: 18 Dec 2009, 07:56 AM
Bookmarks