How to Handle Huge Database in ASP

<i><b>Originally posted by : Niranjan (nlokesh@cns-inc.com)</b></i><br />Hi All<br /><br />I want to know the ways of handling huge database in ASP. <br />Because i have to handle the database which contains 75 million records in database, and it has to handle 200 concurrent users in that site.<br />I want know the ways of handling database <br />i,e by <br /> 1. using COM Components?<br /> or using some other methods.<br />

It doesn't matter if you use ASP or anything else. A db with 75 million records needs some consideration. It must be indexed correctly and so on. All the performance lies in the database, in the first place, not in using COM or direct SQL statements.