[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re: Index only works on 4+ characters?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
What leads you to think it fails to use an index?
You mean it is slow, or are there other indications that it fails to use an
index ???
_Ace
> I just ran into an odd occurrence - is there any reason that a search for
> (attributeName=*abc*) should fail to use an index, while
> (attributeName=*abcd*) will use the index?
>
> It looks like if I do a search for 3 or less characters, it fails to use
> the index.
>
> I'm currently using 2.2.5 with bdb.
>
> Maybe this is fixed in the current version - I read in the change log that
> the bdb index format changed somewhere between version 2.2.5 (which I'm
> currently using) and the current version.
>
>
> The index on the attribute in question is for pres, eq, sub, subany
>
>
> Thanks,
>
> Dan
- --
Ace Suares' Internet Consultancy
NIEUW ADRES: Postbus 2599, 4800 CN Breda
telefoon: 06-244 33 608
fax en voicemail: 0848-707 705
website: http://www.suares.nl * http://www.qwikzite.nl
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)
iD8DBQFAexbJy7boE8xtIjURAolCAJ9NUSSvtF6lYrn+G1xf5gCvpRXoDgCbBbCG
3XjoqAc/TLvM1TROz3arHoc=
=qrtF
-----END PGP SIGNATURE-----