-
Hi all,
Can someone help me in this. Suppose I have a SQL Server 7. For each user, I have to create a database. I have 50 users. In about 6 months time, the 50 users will have about 6-8 gb of data in the database. In such a situation, how would I maintain the database's functionality and performance.
I've put the thread in the database part, I thought there are a few database kings in this forum also. So, Ive put it in this.
Thanx in advance,
Parasuraman
-
what kind of data is it? Would it be possible to archive outdated data in a txt file, then truncate that data from your tables?
-
Just to add to what Crypt said, as long as your databases are designed well, utilizing the Normalization process, and you have indexes set on your important fields, I dont think performance will be an issue. Now if someone's databases are occupied with alot of redundant data, at first it might run ok, but as the databases builds, the database(s) will conform to a bloated Pig....:D
-
Thanx for that Crypt and Lethal.
The database has tables which are normal texts. And as Lethal told, I guess the database's design is down pretty well. It seems to be well normalised.
My question is that, even though the database is well normalised, as the number of users increase and simultaneously the number of databases increase, wouldnt it affect the performance if they are not removed. And also, is there any limitations on the number of databases that can be held in a sql server7
Thanx again
Parasu Raman