Re: Limits on rows in a table
- From: "Stu" <stuart.ainsworth@xxxxxxxxx>
- Date: 27 Apr 2006 08:31:04 -0700
Erland is correct; I personally am running an app that generates
40,000,000 rows of data a day, and it performs well (and it's not a
super server, either). I also suck data out of app by a vendor that
has less than 100,000 rows per day, and it takes hours using their
method.
Not saying you should point the finger at your vendor, but if the
performance of their app is mission-critical, and they value your
business, you need to have a conversation with them about SQL tuning.
Could be something you're doing, or it could be something they're
doing. But it's probably not the engine (unless you're running SQL
Server on a bare-bones server).
Stu
.
- References:
- Limits on rows in a table
- From: chloe . crowder
- Re: Limits on rows in a table
- From: Erland Sommarskog
- Limits on rows in a table
- Prev by Date: Conditional Query
- Next by Date: Re: Compound Primary Key - order not as expected
- Previous by thread: Re: Limits on rows in a table
- Next by thread: Re: Limits on rows in a table
- Index(es):
Relevant Pages
|
