lkml.org 
[lkml]   [2003]   [Oct]   [29]   [last100]   RSS Feed
Views: [wrap][no wrap]   [headers]  [forward] 
 
Messages in this thread
/
Date
From
SubjectRe: Things that Longhorn seems to be doing right
> SQL is a bloated pig; an effective 
> file system needs to be both useful and efficient, leading me to think
> that we should consider a more succinct query mechanism for any
> metadata-based file system.

It's certainly possible to make a mostly/partially SQL compliant query
engine which is lean. We did so for the commercial version of BK, i.e.,
this does exactly what you think it does:

select ID,STATUS,SEVERITY,PRIORITY,SUMMARY
from bugs
where (SEVERITY == 1 or SEVERITY == 2 or SEVERITY == 3) and
(PRIORITY == 1 or PRIORITY == 2 or PRIORITY == 3) and
(STATUS == "new" or STATUS == "open" or STATUS == "assigned")
order by
ID

The code which implements that:

wc query.c select.y
284 830 5679 query.c
650 2033 13775 select.y
934 2863 19454 total

SQL compatibility isn't the problem, full (and bloated) SQL implementations are.
--
---
Larry McVoy lm at bitmover.com http://www.bitmover.com/lm
-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
the body of a message to majordomo@vger.kernel.org
More majordomo info at http://vger.kernel.org/majordomo-info.html
Please read the FAQ at http://www.tux.org/lkml/

\
 
 \ /
  Last update: 2005-03-22 13:58    [W:4.032 / U:0.024 seconds]
©2003-2020 Jasper Spaans|hosted at Digital Ocean and TransIP|Read the blog|Advertise on this site