Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Path: utzoo!mnetor!uunet!seismo!husc6!sri-unix!ctnews!pyramid!uccba!hal!ncoast!allbery From: allbery@ncoast.UUCP (Brandon Allbery) Newsgroups: comp.databases Subject: Re: Long text/binary data columns and performance Message-ID: <3281@ncoast.UUCP> Date: Tue, 21-Jul-87 23:00:37 EDT Article-I.D.: ncoast.3281 Posted: Tue Jul 21 23:00:37 1987 Date-Received: Sat, 25-Jul-87 21:49:26 EDT References: <851@rtech.UUCP> <11872@aero.ARPA> <711@cod.UUCP> <316@oracle.UUCP> Reply-To: allbery@ncoast.UUCP (Brandon Allbery) Followup-To: comp.databases Organization: Cleveland Public Access UN*X, Cleveland, Oh Lines: 31 As quoted from <316@oracle.UUCP> by bradbury@oracle.UUCP (Robert Bradbury): +--------------- | In article <711@cod.UUCP>, walker@cod.UUCP (Janet M. Walker) writes: | > We would like sophisticated 4GL capability AND GOOD PERFORMANCE!! So far I | > haven't found the "best of all worlds". There are RDBMS products which | > have capabilities like binary and unlimited text data types but slower | > performance, etc. I would love to hear from vendors and users alike. | > | The performance of a DBMS with a column this large (when they are | capable of handling them) is limited a great deal by the UNIX file system. | (Standard UNIX file systems are not good for reading/writing large | chunks of data; BSD file systems are somewhat better but 65K chunks | is still pushing things.) +--------------- UNIFY 4.0 provides unlimited-length BINARY and TEXT data types; it also has raw disk partition databases. (However, large data fields promise to have performance slowdowns whether they are on raw disk partitions or not. Don't expect performance in the same region as with 2-byte integers.) I believe ACCELL is available with a UNIFY 4.0 substrate, but I'd ask Unify Corp. about that. I also suspect that UNIFY 4.0 is a different product from UNIFY 3.2, but would like to be proved wrong. (UNIFY 4.0 is out now, I believe, but Plexus is getting ready to ship a UNIFY _3.2_ upgrade. Is Unify slow, or is it Plexus?) -- [Copyright 1987 Brandon S. Allbery, all rights reserved] [Redistribution permitted only if redistribution is subsequently permitted.] Brandon S. Allbery, moderator of comp.sources.misc and comp.binaries.ibm.pc {{harvard,mit-eddie}!necntc,well!hoptoad,sun!cwruecmp!hal,cbosgd}!ncoast!allbery <>