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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate