Optimization on DB's is done at a higher level than an index in any case.
And with that statement, you prove that you don't know what you're talking
about . . . . Optimization on commercial DBs is done at all levels and
anywhere possible.
- - - - -
And by the way, while I would believe that your indexes could be as fast or
faster than any equivalent commercial DB software on small datastores, I
don't believe that they can scale up to the necessary sizes for AGI *and*
remain faster (or even close assuming that you could even handle the scaling
up). There are always trade-offs. Enterprise DBs have accepted unimportant
slowdowns at small scales to optimize for scaling to much larger sizes. And
the kid on the bicycle can get down the street long before the airline pilot
even starts the engines.
----- Original Message -----
From: "David Clark" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, February 21, 2007 2:04 PM
Subject: **SPAM** Re: [agi] Development Environments for AI (a few
non-religious comments!)
On any given machine, indexing code quickly reaches it's maximum speed.
Enterprise DB's are much slower because they have to be concerned with
much
more than just simple indexing. I know for a fact that my indexes are as
fast or faster than any widely used software DB on the same hardware.
Optimization on DB's is done at a higher level than an index in any case.
David Clark
----- Original Message -----
From: "Mark Waser" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, February 21, 2007 6:59 AM
Subject: Re: [agi] Development Environments for AI (a few non-religious
comments!)
> 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.
Wow. You've floored me given that indexes are key to what enterprise DBs
do
well. What are the special requirements/functionalities of the indices
that
you believe that enterprise DBs are not *optimized* to handle?
-----
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
-----
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