From: Pierrick B. <pie...@cu...> - 2007-02-28 16:20:20
|
Hi, Kai Mutz a écrit : > I am not sure if the following has something to with the above bug. I don't think so. All these results seem to be normal. > Hydraulic Power System: 721ms 3 tokens search. More restrictive than the following... > Hydraulic System: 791ms 2 tokens search. > *draulic Power System: 1672ms Initial truncature : scan all over the fulltext index > Hydraulic Power Sys*: 1021ms Right truncature, index scan from "sys" (your fulltext index is probably case insensitive). "Zys*" would have probably been more efficient here ;-) > Hydraulic*System: 310ms (no results) I doubt you have this token in your data, have you ? > Hydraulic * System: 32768ms and more!!! To be understood as : Hydraulic [every token in the full text index] System Cheers, -- Pierrick Brihaye, informaticien Service régional de l'Inventaire / DRAC Bretagne mailto:pie...@cu... / tél : +33 (0)2 99 29 67 78 Avez-vous lu http://usenet-fr.news.eu.org/fr-chartes/rfc1855.html ? |