Re: [bdbxml] Indexing suggestion

John Snelson <[email protected]> Tue, 18 Apr 2006 12:14:08 +0100
Newsgroups gmane.comp.db.dbxml.general
Message-ID <[email protected]>
This is a good interim solution. We have been thinking about some kind 
of case insensitive indexes for a long time now - so rest assured, it is 
certainly on our agenda.

John

Steve Howe wrote:
> Hello Itay,
> 
> Just a suggestion: although I obviously defend the point of XPath
> expression indexes, for your specific application, you could store the
> file name (or any other search data) twice: one as original, and the
> other as lowercase, and then lowercase every search expression too -
> that will match lowercase against lowercase. This should help you while
> we don't have a more flexible indexing. You could even store the
> redundant lowercase data as metadata, so you won't have something ugly
> on your schema. Then when better indexing is supported, you could
> upgrade the databases by removing that data.
> 


-- 
John Snelson, Berkeley DB XML Engineer
Sleepycat Software, Inc
http://www.sleepycat.com

Contracted to Sleepycat through Parthenon Computing Ltd
http://blog.parthcomp.com/dbxml


------------------------------------------
To remove yourself from this list, send an
email to [email protected]