By gdhia on

Hi everybody,

We have asked a professional to create for us a Drupal website. This site has been provided since a year, but since then the SQL database of this site continues to grow in an incredible way.
Indeed, more specifically, it’s the "sessions" table which is 740Mo height.

On our website, the anonymous user provides name and email address to subscribe to the newsletter (simplenews module). A user account is created and a password assigned and sent. I think it's that structure of an account and a password for each user that makes this table that enormous.

Is it possible, while keeping the user table for the administrator of the website, to use another module to manage newsletter subscriptions without that user accounts are created?

Thank you all

Comments

willhowlett’s picture

willhowlett commented

Is cron running reguarly on your site? I'm not entirely familiar with the sessions table off the top of my head but cron does clear out some cache tables when it runs.

If you're not sure you can run cron manually (by visiting yoursite.com/cron.php) and see if that makes a difference to your database size.

Alternatively maybe this module might help? http://drupal.org/project/session_expire