Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance Contains
Ludovic Bostral wrote:
> I use a contains like that :
> CONTAINS(FIELD_VALUE, 'actualite|crime|100 ans|escadron de la mort|800
> ans|peine de mort|guerre civile|900 ans|bicentenaire|prix
> nobel|explosion|violence sexuelle|proces|blesse|droit|crime contre
> l''humanite|lutte|petition|tribunal|terrorisme|occupation|arme|otage|greve|30
> ans|enlevement|casseur|assassinat|50 ans|genocide|legion d''honneur|70
> ans|demission|90 ans|gendarmerie|avocat|corruption|150
> ans|violence|prix|travail d''interet general|crs|manifestation|750
> ans|anniversaire|juge|950 ans|loi|purification
> ethnique|torture|guerre|pedophilie|charnier|greve de la
> faim|massacre|revolte|justice|repression|conflit|juriste|immunite|police|inauguration|affaire|magistrat|attentat|nomination|40
> ans|crime|100 ans|escadron de la mort|800 ans|peine de mort|guerre
> civile|900 ans|bicentenaire|prix nobel|explosion|violence
> sexuelle|proces|blesse|droit|crime contre
> l''humanite|lutte|petition|tribunal|terrorisme|occupation|arme|otage|greve|30
> ans|enlevement|casseur|assassinat|50 ans|genocide|legion d''honneur|70
> ans|demission|90 ans|gendarmerie|avocat|corruption|150
> ans|violence|prix|travail d''interet general|crs|manifestation|750
> ans|anniversaire|juge|950 ans|loi|purification
> ethnique|torture|guerre|pedophilie|charnier|greve de la
> faim|massacre|revolte|justice|repression|conflit|juriste|immunite|police|inauguration|affaire|magistrat|attentat|nomination|40
> ans') > 0
>
> the average time for this query is 10 secondes.
>
> I use Oracle Text for fieldvalue.
>
> Is there a way to upgrade the search time or to obtain a better query ?
>
> Xeon Quadri-Pro
> 2 G RAM
> Oracle database 9.2.0.7
> Windows Server 2003
First thought is that I'd dump Windows and get more RAM. But given what you've got the question might come down to what indexes exist that support the query and are they being used.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Thu Oct 20 2005 - 12:35:35 CDT