Received: from mail.STRATEGICNETWORK.ORG ([216.1.60.176]) by hub.org (8.9.3/8.9.1) with ESMTP id LAA72938 for ; Fri, 23 Apr 1999 11:05:19 -0400 (EDT) (envelope-from justinlong@strategicnetwork.org) Received: from nsmjustinlong [159.26.240.128] by mail.STRATEGICNETWORK.ORG (SMTPD32-5.00) id ADA213900FE; Fri, 23 Apr 1999 11:11:30 EDT Reply-To: From: "Justin Long" To: Subject: Large objects - bug? caveat? feature? Date: Fri, 23 Apr 1999 11:04:07 -0400 Message-ID: <000901be8d9a$88e2d680$0a411a9f@cbn.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Importance: Normal I am using PHP3 with Apache on top of Linux, using beta 2 of PostgreSQL. I have uncovered an interesting (bug/feature?) in the Large Objects. If (using PHP3) you write out, say, a 2,000 byte large object (a text article in this case), and then using an edit routine you replace that 2,000 object with a more concise, edited 1,000-byte document, what you get is the 1,000-bytes of the edit, followed by the final 1,000 bytes of the original 2,000 byte article. In other words, it doesn't shrink the file to the edited size. Secondly, I notice that in my data/base/... area that whenever I create an object it creates a single file on the disk. Does that mean that if I have 100,000 articles in my knowledge base, that it is possible that I will have 100,000 files individual 8-to-10k files on my hard drive? Does Linux suffer degradation in performance when having that many files in a directory? Justin Never retreat. Never surrender. Never cut a deal with a dragon. _______________________________________________________________ Justin Long CIO / Site Editor 616 Station Square Ct Network for Strategic Missions Chesapeake, VA 23320 977 Centerville Trnpk CSB 317 JustinLong@xc.org Va Beach, VA 23463 Check out our site at: http://www.strategicnetwork.org