Webform submission
2015 26 Jul

Archive Webform Submissions

Webform is the 2nd most popular module after views and is widely used. Most of the sites built on drupal are using this module. It gives site administrators the functionality of creating as many forms as needed so that they can use them in surveys, contest, contact us forms etc.

This module also allows you to extract the reports based on these submissions, notify users for their queries and lots of other things. All in a very nice package which just works out of the box.

Having lots of legit webform submissions is good infact it shows that your campaign or survey is rocking out there. You will be very happy to see such a huge response :) But such an overwhelming response comes with a price...:(

What could be the problem with lots of webforms submissions? Suppose you have tons of webform submissions and they all are important for you. You can not let go of them. Imagine the load on your server when you try to download the submissions for last 3 months or one year. The select queries on joins of large tables can take a toll on the performance of the MySQL server. It will directly affect the performance of the site and you will go nuts as to what could you possibly do to prevent this as the requirement is pretty natural. Yes, you can think of increasing the hardware but these are infrequent requests so eventually this becomes a temporary solution, neither a good one nor for the long term.

Archiving old webform submissions sounds like the best solution. The module "webform_archive" does exactly that and frees up the current submissions table. It also allows downloading reports for those archives. Such an archive will reduce overhead on webform submission tables and the database queries for select and the lesser the current number of rows in the webform submissions table, the faster are insert statements executed and that reduces the load on the application and the server to a large extent.

This is one of the reasons I like open source. If you do something as a requirement for which there are no open source contributions, you could pick it as an idea to contribute. And the world makes your contribution better. And then, in future, as and when people start using your contribution, you get more motivated.
 

Module Link: https://www.drupal.org/project/webform_archive

 

Kudos to Drupal Community…:

Latest Blogs

webshop

Drupal: The ideal solution for your e-Commerce Website

In the last few decades, the online merchandising sector has made strides at an unprecedented pace following that, the demand and emergence of many e-commerce platforms are on the rise. 

Read More

Drupal 9 Upgrade

The Roadmap to upgrade Drupal site to Drupal 9

Drupal is approaching with its next big evolution and the upcoming release that is none other than Drupal 9.

Read More

How to Choose Web Development Agencies

Points to check before choosing the right website development company

In today’s day and age, where the digital population is increasing exponentially, no credible business can or should refrain from having a strong and steady web presence.

Read More

Wordpress to Drupal

Should I plan to move my Wordpress Website into the Latest Drupal version?

If you're here, I assume you already have a website built on WordPress but you're not satisfied with it, or perhaps you're here to have a clear idea about why you should give a thought to migrating

Read More