I am creating an application that potentially has quite a lot of rows of data for hundreds of customers. Each set of customer data is only for that customer. There may be some future requirement to summarize the data for all customers, but that is not currently needed. Would it be better to place all the transactional data within one SQL database and one table or separate the customers' data into different SQL databases?
July 17, 2008 4:52 PM
July 17, 2008 5:01 PM