July 3, 2008 at 12:00 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 12:48 am
Please don't coss post. It just wastes time and fragments replies. Many of us read all the forums
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic527770-149-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply