Re: Limits on rows in a table
- From: "David Portas" <REMOVE_BEFORE_REPLYING_dportas@xxxxxxx>
- Date: 27 Apr 2006 02:55:59 -0700
chloe.crowder@xxxxx wrote:
Hi
We received the following in an email from a third-party supplier (who
naturally has a solution for the problem as described). It sounds like
gibberish to me, but does anyone have any comments?
<quote>
SQL in its current incarnation hits a performance brick wall when a
table contains more than about 75 million rows. This is not a
configuration limit as the table could be grown a lot larger but the
performance issue generates problems for ??????; primarily during
search and retrieval of archived objects; although if the database
engine is being heavily hit for retrieval the archiving process can
slow down as well.
</quote>
Chloe Crowder
British Library
"SQL in its current incarnation..."
SQL is a language and it has no such limitations. Did they mean to
refer to Microsoft SQL Server? Either way, their claim is plain
nonsense.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
.
- References:
- Limits on rows in a table
- From: chloe . crowder
- Limits on rows in a table
- Prev by Date: Re: Limits on rows in a table
- Next by Date: MySQL Cluster
- Previous by thread: Re: Limits on rows in a table
- Next by thread: Re: Limits on rows in a table
- Index(es):
Relevant Pages
|
