Re: [mv] Why is MiniVend so slow??

["Keith Pettit" <keithp@censoft.com>]

******    message to minivend-users from "Keith Pettit" <keithp@censoft.com>     ******

Thanks for all the help and suggestions.  I don't know what it was for sure
but I checked the sytem resources while it was slow and it was never using
more that 5 percent.  I did go into the minivend.cfg file and changed it
from low traffic to high traffic, and it seemed to speed it up, but not to
where I want it to be.  This is a pretty robust machine and all it does is
server web pages, and MySQL for those web pages.

Will MinVend speed up any when I switch the database from the standard text
files to MySQL?

I use PHP with MySQL quite a bit and I have to say it's always pretty zippy.
I'm hoping there will be some preformance increace when I move MiniVend to
MySQL.

Anybody have any comments about the speed difference between MySQL and Text
file database?


Keith Pettit
WebMaster
Century Software
keithp@censoft.com
www.censoft.com


----- Original Message -----
From: "Chris Rapier" <rapier@psc.edu>
To: <minivend-users@minivend.com>
Sent: Tuesday, July 18, 2000 2:08 PM
Subject: Re: [mv] Why is MiniVend so slow??


> ******    message to minivend-users from Chris Rapier <rapier@psc.edu>
******
>
>
>
> > Keith Pettit wrote:
> >
> > Whenever I go to the cart, it takes about 5 to 10 seconds to pull up.
> > THat's pretty darn slow, espically when I'm connecting via ethernet.
> > Anyways everything else on the server runs great, it's just the
> > MiniVend stuff that creeps along.
> >
> > This is my URL http://www.censoft.com/cgi-bin/cart
> > I'm still in the testing phase so there is no real load on MiniVend.
> > I used the basic cart as a template, and most everything is pretty
> > standard.  The only real modification I've done is put an include
> > statement to have my header on the cart.
>
> Unfortunately just saying its slow doesn't help us all that much. There
> can be any number of reasons start from the purely phsyical up to the
> abtract construction of the pages. The first thing I would do is make
> sure that it really is just minivend.
>
> Start the minivend server with 0 load and find out how much memory its
> using. Make sure that you have enough memory available so you aren't
> swapping everything out. Put some load on the server again and check the
> memory.
>
> If you have plenty of memory then try changing your database format to
> db or gdbm. If your SQL server is slow its going to slow everything
> down. If you are feeling crazy try making the database type MEMORY.
>
> Then start looking at the docs for issues regarding your OS, perl
> version and version of minivend.
> -
> 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