SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Blobs and Clobs

  1. #1
    SitePoint Member pgirl's Avatar
    Join Date
    Jun 2003
    Location
    New Zealand
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Blobs and Clobs

    Hello..

    I'm trying to design a content management database (logical design only), but I'm stuck.

    The database must store multimedia, and the documents must be searchable, so I have a content table.

    Since some of the data will be blob, and some clob - I don't want to store it all in the same table for normalisation reasons, but if I have seperate tables for blob and clob data.. how can I link them back? I'm stuck with the same problem of one field being empty..

    I think I'm missing something fundamental..

    Any help greatly appreciated.

  2. #2
    Drupaler bronze trophy greg.harvey's Avatar
    Join Date
    Jul 2002
    Location
    London, UK
    Posts
    3,258
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I say this a lot, but don't store your multimedia in the database. It'll slow things down like hell! Store a file name in the database and store the file in a directory of the file system. File systems store files much better than databases.

    G


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •