[ic] Very Slow browse

Jonathan Clark interchange-users@lists.akopia.com
Thu Jul 5 08:39:02 2001


> Hi all,
> I have about 20,000 items in my catalog stored in a MySql database. My
> catalog is based on 'construct' demo and like it  items are grouped in
> category, but when I browse to a single category I have to wait a lot even
> if the category contain few (about 10) items. Tailing the mysql log I see
> that IC execute a query "SELECT * FROM products" that produce a huge
> resultset and then IC filter this query internally for the
> category clicked.

Sounds like your ic search is not coordinated. What is your search
definition for this query?

Jonathan
Webmaint.