If you're forced to use a RDBMS your best bet is probably a serialized PHP array. It will be the fastest to store and extract. However, the best solution for this kind of problem would be to use a document oriented database such as CouchDB or MongoDB. Using one of these you could just put whatever data you want into actual database fields so they are still indexable, queryable, etc.
-- Michael J. I. Jackson http://mjijackson.com/ @mjijackson On Sun, Mar 21, 2010 at 1:06 AM, Wade Preston Shearer < [email protected]> wrote: > I am building a simple survey tool and am trying to determine the best > method for storing the responses. The tool allows an administrator to build > a survey of any length. Due to the dynamic nature of this, it's impossible > to have a database table with the appropriate corresponding columns. What's > the best way to store this? A serialized array? Any way to store it and > still be able to query against the answers? > > _______________________________________________ > > UPHPU mailing list > [email protected] > http://uphpu.org/mailman/listinfo/uphpu > IRC: #uphpu on irc.freenode.net > _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
