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