Hello all, Im looking for Excalibur text search expert here to give me some advice on what I'm currently doing.
OK, is there any way of optimizing below search queries. I mean what would be the best way to do that;
select name from users where etx_contains(name, row('Albert'))
select status from profiles where ext_contains(status, row('complicated'))
select name,district from districts, users where etx_contains(district, row('California'))
and users.district_id = districts.id
From my experience, Excalibur doesn't have its own way to do search on multiple/join tables. So what I did is just like above queries. Is there any way of doing this in much better way ? Sorry for my English.