From owner-freebsd-isp Sat Oct 28 14:39:35 2000 Delivered-To: freebsd-isp@freebsd.org Received: from shell.unixbox.com (shell.unixbox.com [207.211.45.65]) by hub.freebsd.org (Postfix) with ESMTP id F3F3537B479 for ; Sat, 28 Oct 2000 14:39:32 -0700 (PDT) Received: from localhost (fengyue@localhost) by shell.unixbox.com (8.11.0/8.11.0) with ESMTP id e9SLc5968106; Sat, 28 Oct 2000 14:38:05 -0700 (PDT) Date: Sat, 28 Oct 2000 14:38:05 -0700 (PDT) From: FengYue X-Sender: fengyue@shell.unixbox.com To: Mike Cc: freebsd-isp@FreeBSD.ORG Subject: Re: OT: Program Speed In-Reply-To: <4.3.2.7.2.20001028164421.03021200@mail.futuredesigns.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org It'd be alot faster if you change your CGI to be an apache module or use fast-CGI (http://www.fastcgi.com). Process creation is expensive. On Sat, 28 Oct 2000, Mike wrote: ->Sorry for the off topic question, but I'm not quite sure where else to find ->unbiased opinions on this. We currently have a cgi program, written in C, ->that is ran about 500,000+ times a day. Each time it is run, it reads from ->reads and writes to 2-5 flat text files. -> ->I am in the process of rewriting this program so to add more features and ->what not. I am wondering if it would be faster / more efficient if it were ->to use MySQL instead of flat text files (over 500,000 accesses daily) in ->the C version of the program, or would PHP or a combination of PHP/MySQL be ->faster? -> ->Any thoughts/ideas, or a reference as to where I could find such ->information would be greatly appreciated. -> ->Thanks in advance! -> ->Mike -> -> -> ->To Unsubscribe: send mail to majordomo@FreeBSD.org ->with "unsubscribe freebsd-isp" in the body of the message -> -------------------------------------------- | Windmoon ~{#@7gTB?M#@~} | | http://www.windmoon.nu/ | | *** Have you hacked a UNIX laterly? *** | -------------------------------------------- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message