From owner-freebsd-questions Mon Nov 6 6:57:33 2000 Delivered-To: freebsd-questions@freebsd.org Received: from web6104.mail.yahoo.com (web6104.mail.yahoo.com [128.11.22.98]) by hub.freebsd.org (Postfix) with SMTP id 2133B37B4D7 for ; Mon, 6 Nov 2000 06:57:30 -0800 (PST) Message-ID: <20001106145730.23056.qmail@web6104.mail.yahoo.com> Received: from [207.180.222.82] by web6104.mail.yahoo.com; Mon, 06 Nov 2000 06:57:30 PST Date: Mon, 6 Nov 2000 06:57:30 -0800 (PST) From: Shashi Joshi Reply-To: shashi@shift-f1.com Subject: filesystem question To: freebsd-questions@freebsd.org, lowell@world.std.com MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi, What is the limit on number of files/dir/subsirs on a filesystem? Does creating/deleting temp files on a FS stress it too much, is bad for it, canm cause disk errors? e.g. If I have a flat file database which may result in a few thousand files on a FS, (say 5 files per user), and will also result in creating deleting and of course read/write of files. On the other hand, if I install MySql or some other database, then I have only say 10-20 files (including index files) and now the traffic passes through the database thread. I mean instead of reading the OS files directly, the web page will cause a DB query, which will pass file contents (data) to it. Which one is better/How do they compare? Thanks, Shashi __________________________________________________ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message