Page 1 of 1
Is there safe way to Reduce Size of customer_login table in database
Posted: Sun Jun 11, 2023 10:50 pm
by tom327
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?
Re: Is there safe way to Reduce Size of customer_login table in database
Posted: Mon Jun 12, 2023 9:51 pm
by paulfeakins
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.
Re: Is there safe way to Reduce Size of customer_login table in database
Posted: Mon Jun 12, 2023 11:18 pm
by JNeuhoff
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.
Re: Is there safe way to Reduce Size of customer_login table in database
Posted: Tue Jun 13, 2023 10:47 pm
by tom327
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?
Re: Is there safe way to Reduce Size of customer_login table in database
Posted: Wed Jun 14, 2023 7:11 pm
by paulfeakins
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/