[ic] Very Slow browse

Mike Heins interchange-users@lists.akopia.com
Thu Jul 5 12:14:01 2001


Quoting Stefano Malagoli (s.malagoli@datacode.it):
> 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 ?

You should have increased the speed quite a bit by following the
other suggestions (basically remove the urlencode filter, co=yes, op=eq)
but the biggest win is to surround the list builder loop with:

	[timed-build minutes=20]
	   .... the ITL for the catlist ...
	[/timed-build]

There is an option for this in the latest dev version.

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

Friends don't let friends use Outlook. -- Bob Blaylock