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

["Mediaservices" <support@mediaservices.net>]

******    message to minivend-users from "Mediaservices" <support@mediaservices.net>     ******

Hi Keith,

No need for SQL with Minivend. You can use Glimpse and get the performance
with the flexibility of Flat files.

We have over 12,000 products (allot of fields, mighty hefty database) in a
flat format. Using Glimpse we find it faster doing text searches that mySQL
with Minivend. (search time average 1.8 seconds).

I visited your pages, and also found the DNS look up very long (on DSL
512K). DNS took 13 seconds, page in 1.8 seconds.

If you are on a Virtual Server from an ISP then also check out if their are
other users eating to resources. Minivend places allot of demand on Perl and
RAM.

I also saw needless statements in your queries (focus on "keywords" in text
based not whole statements) and the search is faster.

Thank You
Russ Smith
Mediaservices Network

www.ms-links.com
www.goldstats.com
stats@goldstats.com
-----------------------------------------------
www.goldget.com
www.goldsubmit.com
www.goldposition.com
===============================================


-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of Keith Pettit
Sent: Tuesday, July 18, 2000 6:04 PM
To: minivend-users@minivend.com
Subject: Re: [mv] Why is MiniVend so slow??


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

-
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