Hal Kaplan <> wrote:
> => [mailto:[EMAIL PROTECTED] On Behalf Of Stephen the Cook =>
> => Depends on how many inserts are going to take place. The => index
> like that is a poor idea for tables that get a good => deal of new
> rows. => => => Stephen Russell
>
> Maybe so, SR, but adding rows is going to affect any approach. The
> problem is to retrieve and unless you prepare for and plan for
> retrieval, you will not be successful overall.
>
> Of course restricting the number of records that can be added will
> have the positive effect of significantly reducing the number of
> records that can be retrieved. That is why I have always advocated
> content-addressable storage. Content-addressable storage completely
> eliminates the need for data and most metadata and improves
> processing speeds by orders of magnitude ... all for very, very, very
> low cost (no cost, really).
I was responding to multiple indexes in an attempt to hit the sweet spot.
Indexes need to expand to accept elements in the middle. So if you are
constantly doing that adjustment(shift) in four parts of your index file all
at the same time it just screams wrong for high input systems.
CustomerName comes to mind in a huge index repagination problem I had to
deal with. A year ago. I had 1.5 million customers and was adding in batch
mode 10,000 a day. The sp that did the insert one per SP call really hit
the system hard. Each new customer probably had 12 inserts in total.
So how do you retrieve specific content in your "Content-addressable
storage"? I'd like to learn of a different way if it's better and useable!
Stephen Russell
DBA / .Net Developer
Memphis TN 38115
901.246-0159
"A good way to judge people is by observing how they treat those who
can do them absolutely no good." ---Unknown
http://spaces.msn.com/members/srussell/
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.0.0/754 - Release Date: 4/9/2007
10:59 PM
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
