[ic] Using indexes in search

Joshua Lavin interchange-users@icdevgroup.org
Thu Oct 31 16:36:01 2002


>> [page scan se=Pants/sf=Category/va=dept=clothing/mp=sort]Pants</a>
> 
> Add st=text .  I just posted a message yesterday about enhancing
> performance.  Take a look at the thread:

Yes, I did read your post yesterday. Thanks!

I added the st=text, and that really didn't make a difference. However, I
failed to mention that in the one-click search link, there is also "ml=999".
If I take out the ml=999, the search is faster.

Adding the st=text (sans ml=999) to the fast binary search made it only
retrieve the pants (and it was fast; around 3 sec.).

I have the ml=999 in there b/c we import our database from a POS server,
which doesn't handle colors and sizes like IC. They use "Color" and "Size"
columns in the products database. There are 170 rows for the Pants category,
but only 6 different kinds of pants.

Because all the descriptions are identical, and I don't want them all
showing in the results, I have to do [item-change] to remove the color/size
variations. Then, on the flypage I build a custom color/size drop-down box
by searching with the description. Kinda weird, but it works. Slowly.

Leaving out the ml=999 shows only 2 items per page, with 3 or 4 pages of
results. Not nice!

I guess there's not much I can do, aside from getting the POS maker to
rewrite their software.

Thanks,
Josh