[ic] Very Slow browse

Stefano Malagoli interchange-users@lists.akopia.com
Thu Jul 5 09:27:01 2001


----- Original Message -----
From: "Jonathan Clark" <jonc@webmaint.com>
To: <interchange-users@developer.akopia.com>
Sent: Thursday, July 05, 2001 2:37 PM
Subject: RE: [ic] Very Slow browse


> > 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.
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>

This is the page tag I use.

[page search="st=db
              su=no
              em=yes
              ml=10
              fi=products
              sf=category
              op=em
              se=[filter urlencode][cat-data cat name][/filter]
              tf=category
        "][cat-data cat name][/page]