Re: Why Query So Slow?

On 15 May 2012, at 17:22, Alan Tilson wrote:

> I attempted a query on a non-indexed field in a related one table

Unbelievable.

I've been reflecting on this quite a lot lately. We are now 40 years on from E.H. Cod's relational database
theory and the general algorithm for querying is still a sequential search.

In 40 years no one can come up with a faster way of finding something in a relational table structure than
inspecting every single record in the entire table store just to return a few results out of millions. I
think that that one solitary fact alone will spell the deathnell for relational databases as a technology
if nothing else.

It's kind of like discovering heavier-than-air flight but never getting past the biplane. So no public
transport, no jet transport, no supersonic or spacefilght was arrived at because no-one ever invented
the monoplane.

Cross-table querying is the RDBMS's monoplane.

Wakanda seems to have a more holistic approach but that observation puzzles me because I thought they both
used the same DBMS.

Peter

References: http://en.wikipedia.org/wiki/Monoplane

**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************