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]