Re: Minivend vs Others Options

["George Knerr" <gknerr@webalution.net>]

Dear Mr. Christopher F. Miller,

Thank you very much for the encouraging reply.  This site is magnitudes
bigger and more complex than anything I have done thus far.  They want it up
by Jan. 1 2000.  That is of coarse if anything is up ;).

Is there any added difficulty that you are aware of with implementing Oracle
or Sybase with minivend?

If you could be so kind as to be a little more verbose with the following
comment you made:

>Our usual product
> page in typical catalog will frequently have at least one
> 3-5 table multi-database JOIN.  Poorly indexed that's 11 seconds,
> properly indexed .10 seconds in mySQL.

Specifically, what do you mean by "3-5 table multi-database JOIN" and what
in your opinion is an example of a poorly indexed db versus one that cuts
down searches by a magnitude of ~100 as in your example.

Thanks again,

George Knerr
gknerr@webalution.net



----- Original Message -----
From: Mr. Christopher F. Miller <cfm@maine.com>
To: <minivend-users@minivend.com>
Sent: Saturday, July 03, 1999 11:57 AM
Subject: Re: Minivend vs Others Options


> ******    message to minivend-users from "Mr. Christopher F. Miller"
<cfm@maine.com>     ******
>
>
> Check back in archives for "Largest MiniVend Store" or
> some such thread.
>
> Thousands of products are easy.  You can do that
> with mysql on 486 hardware if you can find a suitable 486.
>
> We generally use mySQL - there is no need for the additional
> complexity and overhead in typical minivend app.  Our usual product
> page in typical catalog will frequently have at least one
> 3-5 table multi-database JOIN.  Poorly indexed that's 11 seconds,
> properly indexed .10 seconds in mySQL.
>
> If the client wants Oracle, get the Oracle HOWTO and buy
> Oracle.  Or look at Sybase; they have done a fine service
> to linux community - Sybase is simply **free** for linux.  That is
> a comforting name too.  ;^)
>
> cfm
>
> On Sat, Jul 03, 1999 at 10:19:11AM -0400, George Knerr wrote:
> > Mike,
> >
> > I have done some pretty simple carts using minivend on a virtual server
and have had little to no problems.  I have a very big client wanting a
database driven e-commerce site that they wish to take PUBLIC.  They are
selling information that before the Internet could not have been disseminate
in this fashion.  I thought I would use MySQL and minivend.  But I could do
it (with allot more work of course) in PHP3 and MySQL.  My question to you
is (you being the expert) should I gamble (only a gamble because I haven't
done this size site before) such a big job on Minivend and MySQL.  They will
have thousands of products in the database.  One of the deep pockets keeps
seeing Oracle commercials and so he wants that.  I don't do Oracle, yet.
The machine will have Linux 6.0, latest Apache/PHP3/MySQL, Single PII450,
Asus P2B98-S, 256 Mb PC100 RAM, Enlight Raid w/ 6 4.5Gig SCSI drives.  Any
input from anyone would be great!
> >
> > Also does anyone know of any BIG Name MySQL implementations that I can
show these investors.  I went to the MySQL page and was not impressed with
their showoffs.  One URL they display as an example is YAHOOSUCK.COM.  Not
something I want my investors to see.  If you know what I mean.
> >
> > Thanks,
> >
> > George Knerr
> > gknerr@webalution.net
> >
>
> --
>
> Christopher F. Miller, Publisher                             cfm@maine.com
> MaineStreet Communications, Inc         208 Portland Road, Gray, ME  04039
> 1.207.657.5078                                       http://www.maine.com/
> Database publishing, electronic commerce, office and internet integration.
> -
> 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
>