What about TSearch2

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 Huetor, 150
18008 Granada - Espana
www.trevenque.es | www.kaplan.es