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 <freebsd-questions@freebsd.org>; 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 <shashi_kant_joshi@yahoo.com>
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