[ic] slow one click search

[Chen Naor]

Hi,
IC 4.9.7
PostgreSQL 7.2.3

I'm trying to do a one click search for this query:

select t1.* from products t1, merchandising t2 where t1.sku=t2.sku and t1.category like
'%[sql-param code]%' and t2.featured like '%second%' and t1.inactive='0' LIMIT 4

I end up with the following code, that works, but it is very slow.
The sql query above work fast (run directly on the DB).
Is it possible to do a direct sql query (like in the [query] tag)? or maybe it is possible to
improve the one touch search?
Any idea?

<A HREF="[area href=scan
                        arg=|
                        co=yes
                        st=sql
                        sp=results_p2
                        se=[sql-param code]
                        sf=category
                        sf=inactive
                        se=0
                        sf=merchandising:featured
                        se=second
                        tf=sort
                        to=n
                        bs=1
                        su=1
                        ml=4
                        |]">[sql-param name]</a>

Thanks in advance

Chen Naor
Lilux Systems
http://www.lilux.co.il/
mail: chen@lilux.co.il