Stop saving submissions as XML in a table but instead save the submissions in a table where each element of the submission are saved as a singel row.
Example on sql scheme:
nid unsigned int(10) -- node id of the form
sid unsigned int(10) -- submission id
cid unsigned int(10) -- component id
uid unsigned int(10) -- user who made the submission
created date -- date of the submission
data varchar(255) -- value of the submission
PRIMARY KEY(nid, sid, cid)

This would make it easier to create reports and in other way gather information from the submissions.

Comments

ullgren’s picture

ullgren commented

Changing target release to CVS

ullgren’s picture

ullgren commented

Now saves the submited data as key-value pairs in the following table.

CREATE TABLE webform_submited_data
  ( nid int(10) unsigned not null,
    sid int(10) unsigned not null,
    name varchar(255),
    data blob,
    PRIMARY KEY(nid, sid));
Anonymous’s picture

(not verified) commented