July 3, 2008 at 12:13 am
I have to generate an online survey tool. Using this system we can generate surveys dynamically.
The system may have, say hundred of surveys and related data within it.
Our main concern is that if the entire data is saving into same database that will affect the performance of sql queries. So we have decided to generate separate database for each survey, dynamically from our website. While taking the database design into consideration, please advice me if any better methods are available.
Thanks in advance.
July 3, 2008 at 1:37 am
sreerekhavs (7/3/2008)
I have to generate an online survey tool. Using this system we can generate surveys dynamically.The system may have, say hundred of surveys and related data within it.
Our main concern is that if the entire data is saving into same database that will affect the performance of sql queries. So we have decided to generate separate database for each survey, dynamically from our website. While taking the database design into consideration, please advice me if any better methods are available.
Thanks in advance.
This has been posted and answered at http://www.sqlservercentral.com/Forums/Topic527770-149-1.aspx 🙂 Please do not cross post. SQL Server Central has a brilliant feature that allows people to see all the recently posted messages, no matter which forum these have been posted in, so posting a question once should be enough, and would allow all the answers to go to the same post.
Regards,
Andras
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply