how big is a big database?

"Gildor Oronar" <[email protected]> Wed, 26 Sep 2007 13:50:23 +0800
Newsgroups gmane.text.xml.xindice.user
Message-ID <op.ty8yh91odkk2yv@localhost>
Dear all

As said, starting with 360,000 xml documents (all submitted by XForm) is  
not a big amount, any NxD should work. Then how much documents can be a  
problem that makes the project have to think which NxD to choose carefully?

I seriously lack background information on database scalability. I only  
know for one time when a database capacity become a problem, that a  
colleague of mine has worked on a project with Microsofot SQL server and  
database crash at 3000 stimulated connection (and upgrade hardware doesn't  
improve anything). I mean I just need to be careful, knowing 360k  
documents is small thing is good, but what if we end up with 3600k  
documents? I just wish to be aware what's the next level (of document  
numbers) that I should be aware.

If the project I am working on is really successfull, it might reach 1  
million documents in coming 3 years. I'd like to say this should be the  
max I can guess.

-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/