[mv] minivend generates to much statemants

["Tobias Gebauer" <tobias.gebauer@x9media.com>]

******    message to minivend-users from "Tobias Gebauer" <tobias.gebauer@x9media.com>     ******

Hello list!!!

I´ve noticed, that when i´ve done a querie via Minivend 3.14-4 through sql
like


<a href="[area href=scan
          arg="
              st=sql
              sq=select * from products where category ='d' order by title
          "]"

the mysql.log file generates more queries like

                   3036 Query      select * from products where category
='d' order by title
                   3036 Query      select * from products where code =
'0000000009910'
                   3036 Query      select code from products where code =
'0000000009910'
                   3036 Query      select price from products where code =
'0000000009910'
                   3036 Query      select * from products where code =
'0000000099001'
and so on......

Is this normal on my Minivend 3.14-3, is there a solution to stop this
problem, or does MV4 the same?????

Greetings Tobias





----- Original Message -----
From: "Barry Treahy" <treahy@mmaz.com>
To: <minivend-users@minivend.com>
Sent: Wednesday, May 10, 2000 6:06 PM
Subject: Re: [mv] [mvasp] vs. [perl] - Large Speed Difference


> ******    message to minivend-users from Barry Treahy <treahy@mmaz.com>
******
>
> Mike, the execution time of MV may be the same, but beyond the users
perception of
> speed, wouldn't it still be faster based on total page load time to allow
MV to start
> sending data when it could rather than buffering it all?  Perhaps I'm
missing
> something, but with limited bandwidth connections, wouldn't it make more
sense to allow
> data to flow as ready to avoid choking the connection?
>
> Has anyone ever tested this?  Again, I'm not speaking of MV execution
time, but total
> walk-clock time of the overall page load once MV takes it.  Seems like you
might end up
> with a time line that would provide overlapping and therefore better
throughput
> performance:
>
> +.................. TOTAL ELAPSED TIME ........................+
> +---------MV EXECUTION--------+====DOWNLOAD OF PAGE CONTENTS===+
> +---------MV EXECUTION--------+
>                 +====DOWNLOAD OF PAGE CONTENTS===+
>
> Just a thought FWIW
>
> Barry
>
> Mike Heins wrote:
>
> > ******    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>
******
> > >
> > > Mike,
> > >
> > >   I've been working with the mvasp/perl tag speed problem a little
> > > more and found that the [mvasp] tag is faster (3x) even with
> > > $Document->hot(0).
> >
> > It isn't really faster. It just starts responding faster. The execution
> > time is identical.
> >
> > Minivend builds a page and accumulates responses in a buffer. If you
> > don't use the send=1 attribute in a tag, it will accumulate the entire
> > page and send it all at once. If you use [mvasp] or cause MV to send
> > the response with send=1 in a Minivend tag, then it will start the
> > response before the entire page is run.
> >
> > >
> > >   And with hot(1), the text appears at the beginning of the page,
> > > just like it does with [perl].
> > >
> > >   So it seems that with hot(0), [mvasp] is three times faster
> > > than [perl], while with hot(1), both forms are unusuable (for me)
> > > becuase they write to wrong part of the document.
> > >
> >
> > You need to send the response of the previous part by specifying
> > the send=1 attribute. Then it will come out in the right order.
> >
> > --
> > 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
>
> -
> 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

-
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