Re: Limits on rows in a table
- From: Robert Klemme <bob.news@xxxxxxx>
- Date: Thu, 27 Apr 2006 11:14:24 +0200
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>
I've never heard something like this before. Maybe it's a problem limited to a specific application. Maybe the app uses the DB in bad ways (wrong indexing...)?
robert
.
- References:
- Limits on rows in a table
- From: chloe . crowder
- Limits on rows in a table
- Prev by Date: Declare dynamic Cursor from String
- Next by Date: Re: Limits on rows in a table
- Previous by thread: Limits on rows in a table
- Next by thread: Re: Limits on rows in a table
- Index(es):
Relevant Pages
|
