Re: site is live

["Bill Betz" <bill@pennherb.com>]

> ******    message to minivend-users from allan deleon
<allan@instantsoft.com>     ******
>
>
> Your site is a little slow for a setup with just 1000 products (even over
a T-1!).
>
> We have 500,000 records in our product table on our site and I gotta tell
yah --
> our
> site must be >10 times faster than your site.
>
>     It looks like your CPU is working overtime for just one request (even
for the
> home
> page! -- you can tell by the "waiting for reply" message on the status bar
on your
> browser
> which usually means the server is processing its response to a request) so
I would
> think
> multiple simultaneous requests are going to be a serious problem for you.
>
> There are lots of tricks you can use to speed up your site a little. For
example,
> browsing
> your catalog... Usually, the catalog doesn't change much... you might add
a new
> item once in
> a while and maybe change some prices here and there, but in general it
doesn't
> change
> too often. So what we did was write a little perl script that went through
our
> entire
> product table, split it up into categories (i.e. CD, DVD, LD, Casette,
etc.,),
> split it into
> sub-categories (i.e. Rock, Country, Horror, etc.,) then generated a whole
bunch of
>
> static html files which includes a whole bunch of index files, all
complete with
> the required
> minivend tags for ordering and navigation (this thing generates over 6,500
static
> html files

Hi allan :

Sounds like a great script. Could you post it?

Thanks,

Bill Betz