[ic] timed-build breaks more list - help needed

Aaron Rubin ronnie at karatedepot.com
Mon Jan 26 12:21:28 EST 2004

Instead of usings IC's next page link to a results page with
mv_first_match=# of results returned already.
Haven't tried it, though...

Aaron Rubin
1-877-216-2669 x12

-----Original Message-----
From: interchange-users-bounces at icdevgroup.org
[mailto:interchange-users-bounces at icdevgroup.org] On Behalf Of DB
Sent: Monday, January 26, 2004 8:37 AM
To: interchange-users at icdevgroup.org
Subject: [ic] timed-build breaks more list - help needed

I'm running 4.8.8 using a modified foundation and MySQL. I have about 
150,000 items in the catalog. Instead of the stock category list along 
the left side of the page, I have links to custom pages which contain 

When customers click these links, the search is performed as expected. 
But because the database is getting large, these searches are slowing 
things down. Since the same search is performed each time these links 
are clicked, the timed-build tag should really help reduce the server

On one of these custom pages, I put [timed-build auto=1 force=1 
minutes=0] at the top of the page and [/timed-build] at the bottom. As 
expected the page loaded much faster.. almost instantly. The only 
problem is that the more list no longer functions. When I click "Next" 
or any other link from the more list, I just get the first page again. 
There is a big performance incentive for me to fix this so any hints are

welcomed. I tried moving the [timed-biuld] tage to various places on the

custom page but unless I wrapped almost the entire page, things broke 
(raw ITL tags were shown on the page). Below is an example of one of 
these custom pages' CONTENT section. If I wrap this whole section with 
[timed-build...], I get the speedup but a broken more list.

------ begin code -----

<H2 align="center">Parts for Commercial turf & Golf course</H2> <H3
align="center">These are just our featured products.<br>Use our 
[page parts]<B>Parts Finder</B>[/page] to search the complete
<!-- Parts for Commercial turf & Golf course -->
[if scratch did_order]
[include file="templates/components/cart_display"]
[set did_order][/set]
[search-region  more=1

[set munge_quantity]
	$Scratch->{did_order} = 1;
	@q = split /\0/, $CGI->{mv_order_quantity};
	for (@q) {
		next unless length $_;
		$_ = "=$_";
	@parms = grep /^mv_oi\d+/ && $CGI->{$_}, keys %{$CGI};

	# If we have parms, means an individual buy. If we don't
	# we want to strip empty items
	unless (@parms) {
		@i = split "\0", $CGI->{mv_order_item};
		for(my $i = 0; $i < @i; $i++) {
			next if length($q[$i]);
			$i[$i] = '';
		@i = grep length($_), @i;
		@q = grep length($_), @q;
		$CGI_array->{mv_order_quantity} = \@q;
		$CGI->{mv_order_quantity} = join "\0", @q;
		$CGI_array->{mv_order_item} = \@i;
		$CGI->{mv_order_item} = join "\0", @i;
	my $item = $parms[0];
	$item =~ /(\d+)/ or return;
	my $idx = $1;
	$CGI->{mv_order_item} = $CGI->{$item};
	$CGI->{mv_order_quantity} = "$q[$idx]";

	[bounce href="[history-scan exclude=nothing]"]
[tmp cross_sale][value-extended name=mv_searchspec index=0][/tmp]

<FORM ACTION="[area nothing]" METHOD=POST>
<input type=hidden name=mv_session_id value="[data session id]"> <INPUT
TYPE=hidden  NAME="mv_action" VALUE="refresh"> <INPUT TYPE=hidden
NAME="mv_separate_items"  VALUE="0"> <INPUT TYPE=hidden  NAME="mv_click"

Parts for Commercial turf & Golf course


Showing [matches] of [match-count] matching items

<table width="95%" border="0" cellspacing="0" cellpadding="3"> <tr
   <td align="center" width="55"><b>&nbsp;</b></td>
   <td align="center" width="40%"><b>Description</b></td>
   <td align="center"><b>Price</b></td>
   <td align="center"><b>Qty</b></td>
   <td align="center"><b>Buy</b></td>
   <td colspan="6">&nbsp;</td>


[item-change 1][condition][item-field category][/condition]

<tr class="contentbar1">
   <td colspan="6">&nbsp;[either][value banner_text][or][item-field 

[/item-change 1]

<tr valign="top">
       <td align="left" valign="middle">
<INPUT TYPE=hidden  NAME="mv_order_item"  VALUE="[item-code]"> <a
href="[area [item-code]]">[item-code]</a> </td>

<td align="center" width="55" valign="middle">
<INPUT TYPE=hidden  NAME="mv_order_item"  VALUE="[item-code]">
[if-item-field thumb] <a href="[area [item-code]]"> <IMG
SRC="thumb/[item-field thumb]" ALT="image" border=0> </a>


       <td align="center" valign="middle" width="40%"> <b>[item-field
comment]</b><br>[item-field description]</td>
       <td align="center" valign="middle">[item-price]</td>
       <td align="center" valign="middle"><input type=hidden 
name="mv_oi[item-increment]" value=""><input type=text 
name=mv_order_quantity size=2 value="1"></td>
       <td align="center" valign="middle">

	  	[if session browser =~ /mac/]
			<input type=submit value="[L]Buy now[/L]" 
onClick="this.form.mv_oi[item-increment].value='[item-code]'" border=0>

			<input type=image
onClick="this.form.mv_oi[item-increment].value='[item-code]'" border=0>
[comment] [order [item-code]]Order Now[/order][/comment]

   <td colspan="6"><hr></td>

<tr><td align="center" colspan="6">
        Sorry, no matches for [value mv_searchspec].
Showing [matches] of [match-count] matching items.<BR>
Click below to see more...


     <H3 align="center">These are just our featured products.<br>Use our

[page parts]<B>Parts Finder</B>[/page] to search the complete


------ end   code -----

interchange-users mailing list
interchange-users at icdevgroup.org

More information about the interchange-users mailing list