Re: Wim's Conf Proposal

Jean-Christophe Michel <jc.michel-/aRvmaKoZxNWk0Htik3J/[email protected]>
Newsgroups gmane.comp.lib.binarycloud.devel
Message-ID <[email protected]>
Wim Niemans ri wrote:
> The new configuration draft (short version) has changed in it's definitive 
> form.
> Read it at http://tinyurl.com/4evlt

Good.
Can you plz give example where this '*' syntax is useful ?

I'm afraid of costly qries in db for such paths:

> 'smarty/*' === 'smarty' are equivalent

Most efficient sql: WHERE LEFT(path,6) ='smarty'

> 'smarty/par*' retrieves smarty/parameter_1
>                     and smarty/parameter_2

Most efficient sql: WHERE LEFT(path,10) = 'smarty/par'

> 'smarty/par*/options' retrieves smarty/parameter_1/options
>                             and smarty/parameter_2/options

I don't see sthg else than WHERE paht LIKE 'smarty/par%/options'
   * is it standard sql (postgres? sqlite?)
   * isn't it too long to run
   * such qries cannot be cached efficiently

-- 
Jean-Christophe Michel
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.