[ic] Re: Need to speed up page loading

Grant emailgrant at gmail.com
Thu Aug 9 12:09:31 EDT 2007


> > > Sorry for replying to myself.  Does anyone know which one of these is
> > > generally faster than the other?
> > >
> > > 1.
> > > [loop list="sku1 sku2 sku3 ..."]
> > > [loop-data products title]
> > > [/loop]
> > >
> > > 2. (with proper mysql indexes)
> > > [loop search="search goes here"]
> > > [loop-param title]
> > > [/loop]
> >
> > I'm not sure... try [benchmark] and see :) My inclination is that IC
> > will perform three queries for the first, and one for the second, but
> > I'm not that intimate with the DB code.
> >
> > > Is this the proper way to set up mysql indexes in products.mysql:
> > >
> > > Database products COLUMN_DEF "title=char(100), INDEX(title(100))"
> >
> > AFAIK it doesn't matter what you have in the IC sql definition - MySQL
> > is going to use the index if it can, if you've created the right index.
> > There's a lot to how indexes are used - if you are making a simple
> > equality match on one field, then the difference of adding an index is
> > pretty significant.
> >
> > One thing to look for are calling [data] from other tables inside the
> > query. You can often achieve this nicely with a JOIN.
> >
> > I'm just stabbing in the dark here - feel free to post something more
> > specific if you like.
>
> Here is an oldie, but still applicable:
>
>     http://www.icdevgroup.org/pipermail/interchange-users/2000-November/002176.html

Very good info.  I was surprised to see this:

[data products image [foo-code]]
which is faster than
[data table=products column=image key="[foo-code]"]

I've always named and quoted my parameters because I thought it was
faster.  Is it really faster to position them?

Is PREFIX-calc faster than calc?

- Grant


More information about the interchange-users mailing list