Yes, I'll be filtering by string value. However, I just wanted to see
how long it takes to scan all translations in a particular language.
Drew
On May 15, 2007, at 9:00 AM, Daniel Cristian Cruz wrote:
2007/5/15, Drew Wilson <[EMAIL PROTECTED]>:
=# explain SELECT s.source_id, s.value AS sourceValue, t.value AS
translationValue
FROM
source s,
translation_pair tp,
translation t,
language l
WHERE
s.source_id = tp.source_id
AND tp.translation_id = t.translation_id
AND t.language_id = l.language_id
AND l.name = 'French' ;
QUERY PLAN
---------------------------------------------------------------------
---
-----------------------------------------------------
Merge Join (cost=524224.49..732216.29 rows=92447 width=97)
This way you get all word matches for the French language. Shouldn't
it be all matches for a specific word (s.value = 'word' in WHERE)?
--
Daniel Cristian Cruz
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
