From owner-freebsd-questions@FreeBSD.ORG Tue Mar 29 02:10:15 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 739DC16A4CE for ; Tue, 29 Mar 2005 02:10:15 +0000 (GMT) Received: from smtpout.eastlink.ca (smtpout.eastlink.ca [24.222.0.30]) by mx1.FreeBSD.org (Postfix) with ESMTP id E9FB443D5F for ; Tue, 29 Mar 2005 02:10:14 +0000 (GMT) (envelope-from fairwinds@eastlink.ca) Received: from blk-224-224-109.eastlink.ca (HELO eastlink.ca) (24.224.224.109) by smtpout.eastlink.ca with ESMTP; 28 Mar 2005 22:10:15 -0400 X-BrightmailFiltered: true X-Brightmail-Tracker: AAAAAA== X-IronPort-AV: i="3.91,129,1110168000"; d="scan'208"; a="16137913:sNHT21531232" Date: Mon, 28 Mar 2005 22:10:04 -0400 Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v553) To: Corey Brune From: David Pratt In-Reply-To: <5627053705032817444c6c4df4@mail.gmail.com> Message-Id: Content-Transfer-Encoding: 7bit X-Mailer: Apple Mail (2.553) cc: FreeBSD-Questions@freebsd.org Subject: Re: Max files in unix folder from PIL process X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 29 Mar 2005 02:10:15 -0000 Hi Corey. Thank you for your reply. 800K is pretty significant. Yes, the reason I want to use the filesystem is to avoid the speed problems that come from storing images in the database. I can see there really being no limit when it comes to spreading the numbers thinner but most concerned about so many in a single directory. References to the images will come from the database. Do you don't think I should have any problem with 150 - 175 K in a single directory - no subdirectories - (just 175K jpg image files of a particular size)? I guess you definitely don't want to do an ls. Would that crap out the server? Regards, David On Monday, March 28, 2005, at 09:44 PM, Corey Brune wrote: > > I've had apps that had over 800k subdirectories and files. As long as > you know the filename, performance will not be an issue. However, if > you don't know the full path, then you may want to either redesign the > app or consider storing everything in the DB. The apps that I've seen > had the full path stored in the database, and the image on a file > server. > > I've also had apps that stored everything in the database, and that > turned out to be a nightmare. Eventually, we moved everything from the > DB to the filesystem. > > Corey > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" >