[ic] Very Slow browse

[Stefano Malagoli]

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.
To increase the performance I bypass IC search engine and buid my own browse
page then take as argument the category name e perform a query "SELECT *
FROM producrs WHERE category='some category'" (whit a [QUERY] tag) that is
faster e produce a small resultset.
But doing this I loose some function like [item-change], [more-list] and
[item-alternate]. So before continue to reimplement this function I have
some question.
I don't understand how IC use MySql ?
or if this is the right way to increase the performance with a large db ?

TIA
Stefano.