At 12:19 AM 8/20/98 -0500, you wrote:
>On 19 Aug 98, at 19:25, Tamra R. Heathershaw-Hart wrote:
>
>> My husband and partner would like to pick the brains of all the techies on
>> our list. Those of you who could care less about servers, databases, or
>> the whole NTvsUnix debate might as well skip this whole message....
>
>This whole website and his book should be a must read:
>
>http://photo.net/wtr/rdbms-backed.html
>
>> >Any thoughts on performance, reliability, etc.? I'm biased towards Perl
>> >and UNIX, but maybe NT is really what's best now for the client (my sense
>> >is that ASP offers better performance than Perl). I've heard through the
>
>Ummm...mmm I have no hard facts either. Is ASP not running within
>the webserver -- and if your ASP crashes so crashes the server?
I am in the process of converting a site with 9000+ pages into a
DB (not a simple undertaking). I am running FreeBSD 2.2.2(5)
(and soon they will all be getting upgraded to 2.2.7 - it is free
if you have a net connection or 39.95 for the 4CD set). I also
run MySQL (it is Free for most instances).
I only use C for doing CGI, in my experience with regular perl,
it is massivly faster than perl. I have seen 100's of perl
processes running that were colliding, etc and just driving the
load up to 25+.
I have run NT servers and I try to avoid them like the plague.
>I spoke to a programmer who said that using mod_perl improved speed
>and reduced overhead. I have read the same. It is my opinion that use
>of mod_perl is equivalent if not superior to ASP.
>
>I would say that ASP is probably more efficient than basic CGI.
I write my DB code in C/C++ using GCC.
>
>> >grapevine, though, that NT servers tend to be unstable. The price of
>
>I have the feeling that a properly configured computer with all the
>right versions of NT might be as secure as say BSD Unix or Linux. At
>iserver they use BSD and it is amazing. The NT route binds you to
>depend on M$ -- no doubt about it. The unix route is much more open;
>more freedom.
Not nessesarily. And the $$$ for NT software is another issue
(you will prolly need email capability and for NT mail servers aren't cheap).
>Didn't hotbot go to NT? I would like to see what they say about it.
Personally, since they sold out, I mean converted to MS, I have
NOT been at all pleased with it.. I am annoyed that they force
you to take the cookies or the searches don't work right.
>
>> >miniSQL is attractive ($250!), but it doesn't do transactions
>> >(commit/rollback). I checked the pricing on Oracle and it was fairly
>> >expensive, plus I've heard that Oracle is difficult to install and
>> >maintain. Another question is when/whether you have to put the relational
>> >database on its own dedicated server separate from the machine that's
>> >running the Web server software.
>
>That commit/rollback is important. I would say that msql is good for
>simple applications. What rdbms to choose will depend on what you
>plan to do. I use msql from habit. I would certainly use mysql
>before msql (mysql is free and has a very good reputation -- many who
>once used msql now use mysql and swear by it). But I doubt if it
>supports "commit/rollback".
It doesn't support it for a good reason. It would be slowed down
if they supported it. If you really needed it, you could always
do it by duplicating the DB and then once you "commit" it then
you trash the intermediate DB's.
>If you use perl/dbi then you can change your rdbms and very easily
>use the same scripts by just a few changes.
>
>I don't think "difficult" should stop you. "Buggy" is a word that
>might stop you but not difficult.
>
>It would be interesting to see what the heavily used sites are using
>in terms of all of the above.
Our site is getting more and more hits we are averaging about 70
thousand page views a day (with peaks around 85K). So far, one
section is in the DB and I am converting the others slowly. I
hope that I can have the site in a DB completly by Jan 1, 1999 (I
doubt it but it is a nice goal).
Matt Soffen
==============================================
Boss - "My boss says we need some eunuch programmers."
Dilbert - "I think he means UNIX and I already know UNIX."
Boss - "Well, if the company nurse comes by, tell her I said
never mind."
- Dilbert -
==============================================
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
