Re: [mv] [mvasp] vs. [perl] - Large Speed Difference

[Mike Heins <mikeh@minivend.com>]

******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******

Quoting Lee Nelson (jld123@pobox.com):
> ******    message to minivend-users from Lee Nelson <jld123@pobox.com>     ******
> 
> Hello,
> 
>   I noticed tonight that SQL queries using the %Sql hash are much
> faster (about 3x) under [mvasp] then they are under [perl].
> 
>   The only difference between the two implementations is that
> I use HTML to write the values into the document under [mvasp],
> and simply reference my constructed string last under [perl].
> 
>   I'm starting both tags with the "tables" parameter as such:
> 
>    [perl tables="mv_products"]
>    [mvasp tables="mv_products"]
> 
>   And I'm using Minivend 4.04, with MySQL 3.22.32.  I
> measured the speed of page delivery using http_load.
> 
>   What would cause this kind of dramatic speed difference?
> 

Depends on the size of the page, and the status of $Document->hot().
If it is a large page, MVASP will write results immediately during
processing if in hot mode.

Actually, [perl ..] will do the same if you do:

	$Document->hot(1);
	HTML $string;

-- 
Internet Robotics, 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <mikeh@minivend.com>

Research is what I'm doing when I don't know what I'm doing.
-- Wernher Von Braun
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list