X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1ABA69DC861 for ; Tue, 31 Jan 2006 20:37:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01352-03 for ; Tue, 31 Jan 2006 20:37:56 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id C3BFE9DC827 for ; Tue, 31 Jan 2006 20:37:51 -0400 (AST) Received: from gghcwest.com (adsl-71-128-90-172.dsl.pltn13.pacbell.net [71.128.90.172]) by svr4.postgresql.org (Postfix) with ESMTP id A75105AF091 for ; Wed, 1 Feb 2006 00:37:55 +0000 (GMT) Received: from toonses.gghcwest.com (toonses.gghcwest.com [192.168.168.115]) by gghcwest.com (8.12.10/8.12.9) with ESMTP id k110bomd022127 for ; Tue, 31 Jan 2006 16:37:50 -0800 Received: from jwb by toonses.gghcwest.com with local (Exim 4.52) id 1F460O-0001gm-A2 for pgsql-performance@postgresql.org; Tue, 31 Jan 2006 16:37:52 -0800 Subject: Re: Storing Digital Video From: "Jeffrey W. Baker" To: pgsql-performance@postgresql.org In-Reply-To: <3cf983d0601311632t4a2f068au1f958746c2b092a7@mail.gmail.com> References: <3cf983d0601311632t4a2f068au1f958746c2b092a7@mail.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Tue, 31 Jan 2006 16:37:51 -0800 Message-Id: <1138754271.6296.4.camel@toonses.gghcwest.com> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/43 X-Sequence-Number: 17029 On Tue, 2006-01-31 at 16:32 -0800, Rodrigo Madera wrote: > I am concerned with performance issues involving the storage of DV on > a database. > > I though of some options, which would be the most advised for speed? > > 1) Pack N frames inside a "container" and store the container to the db. > 2) Store each frame in a separate record in the table "frames". > 3) (type something here) How about some more color? _Why_, for example, would you store video in a relational database? -jwb