Re: Storing questionnaire data

On Fri, Oct 24, 2008 at 09:34:20AM +0100, Thom Brown wrote:
> Thanks David and Jeff.
>
> I can see your point. The provided link might actually be useful,
> although I think I'd make some changes to it.

Good :)

It's not meant to be holy writ, just a way to see how you might
approach this problem without getting the EAV monkey on your back.
That monkey slowly turns into an 800-lb gorilla, and then grows very
quickly, crushing your app.

> I wouldn't have trouble data-mining such a structure for individual
> questionnaire results. The planner will be shrugging its shoulders,
> but I haven't actually tested that solution with many massive
> questionnaires for its query performance.
>
> I pretty much have my answer. Thanks for your input guys.

Happy to help :)

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate