[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference decwet::windows-nt

Title:Windows NT
Notice:See note 15.0 for HCL location
Moderator:TARKIN::LIN.com::FOLEY
Created:Thu Oct 31 1991
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:6086
Total number of notes:31449

5797.0. "Compression and record based files." by PGREEN::SACKMANJ (Pedalo'ing the Internet) Thu Mar 13 1997 00:01

    Question regarding NTFS compression:
    
    A customer of mine, from Oracle, wondered how compression deals with
    records in a database. If a record is changed from 48 bytes to 52 bytes
    as a result of an update, what will NTFS compression do with that
    record?
    Presumably it will either: not work on record based files, or move the
    record to beyond the last record. Any ideas?
    
    		Jon.
T.RTitleUserPersonal
Name
DateLines
5797.1BHAJEE::JAERVINENOra, the Old Rural AmateurThu Mar 13 1997 01:306
    NT[FS] files aren't "record based"; they're just streams of bytes. I
    don't think compression is relevant here. It's up to the application
    (like a database) to decide how to implement a record structure and
    what to do with variable length records.
    
    
5797.2Database needs its own driver?PGREEN::SACKMANJPedalo'ing the InternetFri Mar 14 1997 00:044
    Thanks thats what I thought. Does that mean that the database would
    need its own file system driver to handle records?
    
    		Jon.
5797.3BHAJEE::JAERVINENOra, the Old Rural AmateurFri Mar 14 1997 01:104
    I know close to nothing about databases, but to give any structure to
    data would be the responsibility of the application, not the file
    system.
    
5797.4KANATA::TOMKINSMon Mar 17 1997 10:5410
    I find this particular thread interesting in that, it causes me to pose
    a question.
    
    Can not the File System in it's normal operation have an adverse impact
    on the operation of the database?
    
    Thus, the question of compression may in fact have a very important
    aspect to it from a processing perspective.
    
    rtt