Results 1 to 4 of 4

Thread: Database maintanance

  1. Mar 11th, 2001, 11:32 PM #1
    Parasu Raman
    Parasu Raman is offline

    Thread Starter
    Addicted Member
    Join Date
    Feb 2001
    Location
    Chennai, India
    Posts
    219
    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
    Om Nama Sivaya!!!
    Reply With Quote Reply With Quote
  2. Mar 11th, 2001, 11:43 PM #2
    crptcblade
    crptcblade is offline
    The Devil crptcblade's Avatar
    Join Date
    Aug 2000
    Location
    Quetzalshacatenango
    Posts
    9,091
    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?
    Laugh, and the world laughs with you. Cry, and you just water down your vodka.


    Take credit, not responsibility
    Reply With Quote Reply With Quote
  3. Mar 11th, 2001, 11:56 PM #3
    Lethal
    Lethal is offline
    PowerPoster Lethal's Avatar
    Join Date
    Oct 2000
    Location
    Ohio
    Posts
    2,496
    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....
    Reply With Quote Reply With Quote
  4. Mar 12th, 2001, 04:57 AM #4
    Parasu Raman
    Parasu Raman is offline

    Thread Starter
    Addicted Member
    Join Date
    Feb 2001
    Location
    Chennai, India
    Posts
    219
    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
    Om Nama Sivaya!!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width