Clustered indexing *WILL* solve your problem if you're willing to include
all the data you're going to need in the index. It's definitely a trade-off
. . . . but arguably a solid one.
----- Original Message -----
From: "YKY (Yan King Yin)" <[EMAIL PROTECTED]>
To: <agi@v2.listbox.com>
Sent: Thursday, April 17, 2008 1:03 PM
Subject: Re: [agi] database access fast enough?
On 4/17/08, J. Andrew Rogers <[EMAIL PROTECTED]> wrote:
Again, most good database engines can do this, as it is a standard access
pattern for databases, and most databases can solve this problem multiple
ways. As an example, clustering and index-organization features in
databases address your issue here.
Thanks... clustered indexing looks promising, but I need to study it
in more details to see if it really solves the problem...
YKY
-------------------------------------------
agi
Archives: http://www.listbox.com/member/archive/303/=now
RSS Feed: http://www.listbox.com/member/archive/rss/303/
Modify Your Subscription:
http://www.listbox.com/member/?&
Powered by Listbox: http://www.listbox.com
-------------------------------------------
agi
Archives: http://www.listbox.com/member/archive/303/=now
RSS Feed: http://www.listbox.com/member/archive/rss/303/
Modify Your Subscription:
http://www.listbox.com/member/?member_id=8660244&id_secret=101455710-f059c4
Powered by Listbox: http://www.listbox.com