Mailing List Archive


Back to the month index Back to the list index
Anderson, Hans (hans@marsweb.com)
Mon, 02 Sep 1996 03:27:41 -0700 

Message-Id: <322AB69D.4AF1@marsweb.com>
Date: Mon, 02 Sep 1996 03:27:41 -0700
From: "Anderson, Hans" <hans@marsweb.com>
Subject: Re: [mSQL] Chat Rooms

Soorena Salari wrote:
>
> Hi,
> I tested it, it looks great!
> Do you have any stats on the performance overheads yet?
>
> Soorena

Thanks! I did rudimentary testing. I am currently revamping my entire
site, and will debut it all at once, but I need to test it with 20
people first, to make sure it holds up. However, I have written the
exact same interface in Cold Fusion (for NT) and Visual Basic, using
Netscape's Enterprise Server. Each time the database was accessed to
insert or select (remember, 20 or more people posting and refreshing
every 20 or so seconds...!!) it topped out the server. *Each time*.
Obviously, I yanked it in a matter of hours. There were all kinds of
troubles.

I ran "top" on our FreeBSD system, and watched it refresh from two
machines. It (Apache httpd and mSQL msqld) showed a total of .87% of
cpu use, on average, to refresh the pages (doing selects). Compared to
the NT problems, (100% for *one*), this is much better (.87% for two).

Obviously, it needs much more testing before I would do any important
chat rooms, but in exchange for some help in that arena, I am willing to
improve it with multiple rooms, etc. until everyone thinks it will work
well enough.

One question I do have, being pretty new to UNIX, what is the deal with
PHP/FI and dbm tables? Would it be better to use dbm tables instead of
msql, or is it even possible? Remember, I'm not doing any likes or
wheres or ands or ors, it's simply reading and writing. Opinions: for
chat, mSQL vs dbm.

Thanks!

>
> At 05:19 AM 9/1/96 -0700, Anderson, Hans wrote:
> >For those of you who are interested and that are running MSQL and
> >PHP/FI, I have a chat room that you can have/test. Call it beta 1.
> >It's fully functional, though.
> >
> >I will soon be adding a choice of rooms, etc.
> >
> >Give it a test and let me know what you think. Right now, there's a
> >version up (temporarily) at http://deimos.marsweb.com/~hans/chat/
> >
> >If you want it, I'll email it to you. If it is popular, I'll try to
> >upload it to one of the archive sights.
> > 

-- 
Hans Anderson  -- Hans Anderson  -- M@RSweb 
hans@marsweb.com -- eieio@marsweb.com
http://www.marsweb.com | http://www.ism.net
(406) 721-MARS | 288 Expressway | Missoula, MT  59802

              Too much of a good thing makes it a great thing
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!