|
Subject:
|
capacity of SQL Server 7.0
|
|
Posted By:
|
trangd
|
Post Date:
|
1/30/2004 1:33:32 PM
|
Hi Nik,
To answer your question about why i have multiple talbes with same fields. I have read some where that each table in SQL Server 7.0 only can have 2000 rows max. If i put all the tables together i might have a total of 25,000 rows. I don't know if that is ok and would it take forever to load the data?
thanks
td
|
|
Reply By:
|
nikolai
|
Reply Date:
|
1/30/2004 3:45:32 PM
|
Where did you read that? The number of rows in a table is only limited by the resources on your machine. And as far as how much time it'll take, it would probably take about as much time (if not less) to scan through one table using index seeks and scans as it would to join 13 different tables for an equivalent query.
http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_8dbn.asp
Take care,
Nik
http://www.bigaction.org/
|
