=> [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). B+ HALinNY _______________________________________________ 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.
