Is there safe way to Reduce Size of customer_login table in database

Quote

Post by tom327 » Sun Jun 11, 2023 10:50 pm

Using Opencart 3.0.3.2
I noticed my customer_login (oc_customer_login) table has become very large with over 30,000 rows.
Is it safe to delete these records in customer_login?
tom327
Active Member
Posts
206
Joined
Thu Feb 16, 2012 7:33 am
Top

Re: Is there safe way to Reduce Size of customer_login table in database

Quote

Post by paulfeakins » Mon Jun 12, 2023 9:51 pm

tom327 wrote: ↑
Sun Jun 11, 2023 10:50 pm
 become very large with over 30,000 rows.
For a database that isn't really very large.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk

User avatar
paulfeakins
Legendary Member
Online
Posts
10008
Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Top

Re: Is there safe way to Reduce Size of customer_login table in database

Quote

Post by JNeuhoff » Mon Jun 12, 2023 11:18 pm

All it does is to record the number of login attempts for a customer, this is usable for rejecting customers when they try to do too many failed account login attempts.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Online
Posts
7446
Joined
Wed Dec 05, 2007 3:38 am
Top

Re: Is there safe way to Reduce Size of customer_login table in database

Quote

Post by tom327 » Tue Jun 13, 2023 10:47 pm

I backed up my database and the size was 25 MB? That is why I was concerned and was looking for some tables I could reduce in size.
Is that size database OK?
tom327
Active Member
Posts
206
Joined
Thu Feb 16, 2012 7:33 am
Top

Re: Is there safe way to Reduce Size of customer_login table in database

Quote

Post by paulfeakins » Wed Jun 14, 2023 7:11 pm

tom327 wrote: ↑
Tue Jun 13, 2023 10:47 pm
 I backed up my database and the size was 25 MB? That is why I was concerned and was looking for some tables I could reduce in size.
Is that size database OK?
Well, we've seen much bigger.

If you want to optimise your whole site, I'd suggest one of our Technical Audits: https://www.antropy.co.uk/services/technical-audit/

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk

User avatar
paulfeakins
Legendary Member
Online
Posts
10008
Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: No registered users and 34 guests