Re: [mv] Unusually high load

["Christopher P. Lindsey" <lindsey@mallorn.com>]

******    message to minivend-users from "Christopher P. Lindsey" <lindsey@mallorn.com>     ******

> I just gave it a quick look.  I'd suggest using the MV search
> facilities.  You can build a one click search using SQL and
> let MV take care of the paging for you.  That way you only need a 
> single SQL query to get all your results.  Search the archives
> for "scan and JavaScript" for some examples.

I'm confused...  It's only doing one query.

Or are you saying that it doesn't just do something like return an array
of matches, then loop through it?  Ick.  It still shouldn't push the
load that high, though...

Will a search interface allow me to define my own queries with LEFT JOINs,
etc?   

Chris
-
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