You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
I've got ~20MB (almost 70kof them) of sessions in my database. Besides simply emptying the table how can I keep sessions limited in the database? I don't mind a potential customer visiting, leaving and then returning say a week later and having his/her session saved. That's cool - but how do I limit sessions to a week or so or whatever to keep the MBs reasonable?
Did I miss a setting?
Offline
Session retention is configured in admin under Home > Hybrid X Core > Settings: Application Settings Menu > Cron Settings and the minimum retention period is one month. The default it six months.
Offline
thanks -- figured I missed a setting.
Offline
I believe this same problem is what is causing SUPER DELAY on my website.
It takes 1 minute to log in in admin area and I can no longer get offline credit card information or get contact messages.
Shouldn't ClickCartPro Super users have the ability to delete all these at one shot instead of waiting a whole month?
I get thousands of visitors in a day and their sessions ties down my whole operation. Some are even duplicates.
I want to know the fastest way to delete all data from ccp0_cart, khxc_sessions, xbak567a_khxc_sessions, xbakp6nu_khxc_sessions, xbaky1q6_ccp0_cart, xbaky1q6_khxc_sessions, in Raw Database Admin
Hopefully, it could also help my secure credit card work too.
Offline
Please, you've now asked this question 3 times in 3 different places. This was answered in .
It's doubtful that the sessions table has anything to do with delays. I'll guess that you're on a shared server and the combined load of the sites on the server is most likely the reason for any apparent slowness. All of the xbak tables are backups which are created when you use the backup option in admin. They have nothing to do with the day to day operation of the site. And none of the tables have any relationship to whether or not credit cards will work.
Offline
I am on a Godaddy dedicated server and only using 2-3 of my traffic allocation and 1 percent of my server space.
Offline
Traffic and disk space have very little, if anything, to do with delays. Delays are, almost all of the time, related to the speed of the server and the connection speed between the visitor and the server. There ARE cron jobs that CCP runs once a day and once a week which MAY result in a slight delay the first time the site is visited but, under normal circumstances, that delay would be very brief and happen, at most, once a day.
Offline
I even get 1 minute delay when logging into the software.
This delay also happens when customers try to send me messages from the website. They get an error message after more than 1 minute delay.
Also, this causes the offline credit card data, which is my last hope since the secure credit card never worked, from being sent to my e-mail.
Thanks.
Offline
I can assure you that it is a problem with your server. If you have a number of backup tables in your DB try removing them. But even with hundreds, or even thousands, of them it should not have an impact.
Offline
Here is the contact page: http://theafricanstore.org/index.php?ap … ns=contact
Try sending a message and you will see what I mean by delay and later error message.
Thanks
Offline
Sending delays are more likely caused by the SMTP server being used. The web server itself isn't really involved at all when it comes to sending mail (other than by virtue of the fact that PHP is doing the send and happens to be running within the web server context). From the looks of the failure on the contact page it would appear as though the SMTP settings are not valid/correct.
The pages of the site seem to be loading quickly enough and without hesitation or delay.
Offline