Hi again guys, :)
Sure, even the request would be lighter but a lot, if it's one per language
because so far it looks like that :
SELECT ...
IF(video.language = 'fr', video.title, NULL) as
title_fr,
IF(video.language = 'en', video.title, NULL) as
title_en,
IF(video.language = 'de', video.title, NULL) as
title_de,
IF(video.language = 'es', video.title, NULL) as
title_es,
IF(video.language = 'nl', video.title, NULL) as
title_nl,
IF(video.language = 'el', video.title, NULL) as
title_el,
IF(video.language = 'ja', video.title, NULL) as
title_ja,
IF(video.language = 'it', video.title, NULL) as
title_it,
video.description,
IF(video.language = 'fr', video.description, NULL) as
description_fr,
IF(video.language = 'en', video.description, NULL) as
description_en,
IF(video.language = 'de', video.description, NULL) as
description_de,
IF(video.language = 'es', video.description, NULL) as
description_es,
IF(video.language = 'nl', video.description, NULL) as
description_nl,
IF(video.language = 'el', video.description, NULL) as
description_el,
IF(video.language = 'ja', video.description, NULL) as
description_ja,
IF(video.language = 'it', video.description, NULL) as
description_it,
... FROM ....
If I manage that in multi-core .. how can I manage to do that ? if zero then
core1
1. search "chien" in core0 (english)
2. if #1 returned zero results search for "chien" in core1 (french)
Thanks a lot,
--
View this message in context:
http://www.nabble.com/Multi-language-solr1.3-what-would-you-reckon--tp19954805p20032780.html
Sent from the Solr - User mailing list archive at Nabble.com.
