What about TSearch2

["Rafael Comino Mateos" <ccomino@xxxxxxxxx>]

Hi from Spain,

 

I have a problem with TSearch2,

I have a table with more than a million registers (a table of books, for example),

I made a tsearch2 index for one of my fields (the title of the books, for example),

I make queries from that table, over the tsearch2 index. Then some of my queries get too much slowly, and I don’t know how to resolve it. For example:

• Every thing is ok, but when the query get a lot of results (about 1000 register) and I use ORDER BY over other field in the query (even if I use LIMIT 10) the query gets slowly, 7 or 8 seconds. The thing is, that query gets all the results and later order those results, and that makes my query so slow. How can I resolve this.
• When my queries have two conditions joined with AND, and each condition is made over a different tsearch2 index, the execution get first x rows from the first condition, and y rows from the second condition, later get the rows from both result set. This makes my queries slow too. How could I resolve this?.

 

(Sorry for my English, and thanks for reading me)

 

Grupo Trevenque Kaplan

– – – – – – – – – – – – – – – – – – – – – – – –  

Rafael Comino Mateos

Desarrollo a medida

– – – – – – – – – – – – – – – – – – – – – – – –  

T_ (+34) 958 18 30 30

Camino Bajo de Huétor, 150

18008 Granada – España

www.trevenque.es | www.kaplan.es