On Wed, Feb 21, 2007 at 08:59:51AM -0500, Mark Waser wrote: > >I am pretty confident that the specialized indices we use (implemented > >directly in C++) are significantly faster than implementing comparable > >indices in an enterprise DB would be.
I'm not sure what discussion of databases has anything to do with AGI. > Wow. You've floored me given that indexes are key to what enterprise DBs "Enterprise" is not a technical term. http://lists.canonical.org/pipermail/kragen-tol/2005-April/000772.html > do well. What are the special requirements/functionalities of the indices > that you believe that enterprise DBs are not *optimized* to handle? Relational databases are designed to do well at about anything, sans further tuning. Because of this relational databases perform very poorly for selected applications, many of them trivial, some complex, which are typically much better handled by custom code. An example of where "enterprise" DBs fall flat onto their indices is e.g. a multithreaded similiarity search on 5 million molecules. There are tons of other examples. -- Eugen* Leitl <a href="http://leitl.org";>leitl</a> http://leitl.org ______________________________________________________________ ICBM: 48.07100, 11.36820 http://www.ativel.com 8B29F6BE: 099D 78BA 2FD3 B014 B08A 7779 75B0 2443 8B29 F6BE ----- This list is sponsored by AGIRI: http://www.agiri.org/email To unsubscribe or change your options, please go to: http://v2.listbox.com/member/?list_id=303
signature.asc
Description: Digital signature
