Max no. of rows can SQL Server 6.5 support?

[Patrick Leung]

Hi,

Does anyone know what is the max no. of rows which SQL Server 6.5 can
support without degrading of performance?

Thanks

[Tony Rogerson]

Patrick,

It's like asking how long is a piece of string.

The answer depends on some of the following:

Hardware specification (memory, disk speed)
How wide is your table (average row length)
How many indexes on the table and how wide
Types of operations you want to perform on the table
What is your planned maintanence routines?

The biggest system I worked on had a couple of tables with in excess of 15
million rows and performance wasn't a problem because we where doing small
transactions (OLTP) - the problem only came when doing DBCC's (database
consistency checks) which took many many hours - this has significantly been
improved in 7.0.

Perhaps the best approach would be to tell us a breif about what you want to
do and the news group will give you advice.

--
Tony Rogerson MCP, SQL Server MVP
Torver Computer Consultants Ltd.

www.sql-server.co.uk [Code/Examples library + Neil Pike's FAQ]

Patrick Leung <pat...@kenwoodhk.com.hk> wrote in message
news:7oo58q$c2l$1...@news.hk.linkage.net...

[Neil Pike]

Patrick - there is no limit as long as access is indexed

> Does anyone know what is the max no. of rows which SQL Server 6.5 can
> support without degrading of performance?

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to the newsgroup unless indicated otherwise)
For SQL FAQ entries see
sqlfaq.zip in http://go.compuserve.com/sqlserver. Download from lib 1.
or www.ntfaq.com/sql.html (download as part of ntfaq)
or http://www.swynk.com/faq/sql/sqls