Have an idea?

Visit Sawtooth Software Feedback to share your ideas on how we can improve our products.

Best practice re database setup and management

Hi all

What is best practice when managing databases in V8?  All jobs in the one database?  Separate database set up for each job?  A new database set up each month?  Interested to know how folk have chosen to run things and the reasons (if any) behind their decisions.

BTW, we are running 8.2.4 and mySQL.

Cheers
Marion
asked Sep 6, 2013 by Marion Bronze (3,580 points)
retagged Sep 6, 2013 by Walter Williams

2 Answers

+2 votes
Hi,

I am using one database for all studies. I created separate database only if any survey is going live always and i am using tables to show reports. If there isn't any other reporting type requirement. I always use same common database.
answered Sep 6, 2013 by Rajesh Rana Gold (23,660 points)
+1 vote
Hi Marion

I setup a new database per survey. Thinking this might make deleting/archiving a survey easier. I need to try keep the number of files on my server down rather than the number of databases. Deleting an entire database seems easier/safer than removing tables from within a database???

Cheers
Russell
answered Sep 6, 2013 by rapizel Bronze (1,420 points)
...