[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Unusually high load
****** message to minivend-users from Dan Busarow <dan@dpcsys.com> ******
On Mon, 10 Jan 2000, Christopher P. Lindsey wrote:
> > 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.
Looked to me like it was doing two or more on each result page. And
semi-expensive ones at that. Plus all the perl to keep track of
where you are in the set.
> 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...
That's what it does. But if your results take long enough that you get
several minivends running at once you'll see a performance hit. In my
experience handing things off to scan ends up being much faster and
easier to code to boot.
> Will a search interface allow me to define my own queries with LEFT JOINs,
> etc?
Yes, there's a special variable you can pass to scan with the complete
SQL statement in it, sorry don't remember what at the moment. Make a
test search page and use the standard results.html just to see if it helps.
Dan
--
Dan Busarow 949 443 4172
Dana Point Communications, Inc. dan@dpcsys.com
Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82
-
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
