1 2 Previous Next 25 Replies Latest reply: Dec 27, 2013 10:52 AM by jgarry RSS

    Split the data and call the Main SP

    936666

      Hi,

      I am having a big data say there are about 800 MB of BLOB data

      I know the size of the blob data and the size of data which needs to be split-ted and inserted in to table 

      For a single column i know it is 100 bytes of data on taking this 100 bytes i will be inserting into a table which is having 30 columns.

      Since reading a 800MB of Blob and splitting takes more time,have a idea of splitting the BLOB in pieces of 4, so that i can reduce the overhead

      Split the BLOB into say 4 piece each 200MB and call a Stored procedure which is used as regular one.

      How to Pass the splitted 200MB * 4 of BLOB to my stored procedure

      Current SP will be

      exec SP_name (800MB BLOB_DATA,SIZE_BLOB)

      New one will be something like

       

      Create procedure New_BLOB(800MB BLOB_DATA,SIZE_BLOB)

      As

      BEGIN

      exec SP_name (200MB BLOB_DATA,SIZE_BLOB);

      exec SP_name (200MB BLOB_DATA,SIZE_BLOB);

      exec SP_name (200MB BLOB_DATA,SIZE_BLOB);

      exec SP_name (200MB BLOB_DATA,SIZE_BLOB);

      END;

       

      so how do this ?

      Will there be improve performance if i split and Insert?

      Needs complete as a single output (Fail/Success). not as 4 output(Fail/Success).

       

      THANKS!!

        1 2 Previous Next