In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:
> Have you considered splitting this into two queries? One query can gather
> information from your token and token_ins tables. The other would join the
> first queries results to the other tables to complete your original query.
> Depen
Have you considered splitting this into two queries? One query can gather
information from your token and token_ins tables. The other would join the
first queries results to the other tables to complete your original query.
Depending on your data, one of these subqueries should return a smaller
Hum,
Well, I'm back with another one... When adding a
join to the previous query, it sloows down once again
even though it retrieves less datat. Here's the info :
mysql> explain SELECT ti.posi, ti.docid, d.filename,
ti.id, c.name
FROM corpus_documents cd, corpus c, documents d,
tokens_ins ti,
