Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Speed differences between varchar2 and blobs


    Does anyone have a vague idea, how much speed difference there is aproximately between reading data of approx 3k from a varchar2 field as opposed to from a blob field? (the blob having its own tablespace of course) What about writing?

    I'm using embedded SQL in C++.


  2. #2
    Join Date
    Oct 2003
    I suggest that you do empirical measurements. Normally, BLOB fields are oriented toward holding "huge" amounts of information, such as entire documents or photos, while VARCHARx fields are geared toward "modest" sizes. Paragraphs. Things that can be full-text-indexed.

    So, of the two, VARCHARx fields sound to me to be more appropriate but if speed is the overweening concern the only way to be sure is to set up a couple of test cases and measure.
    ChimneySweep(R): fast, automatic
    table repair at a click of the

Posting Permissions

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