Performance issue in IMAGE field

• MSSQLBuddy

  SSCrazy

  Points: 2354

  More actions

  October 6, 2008 at 3:15 am

  #191739

  Hi All,

  I have the foll issue. Please help me in resolving this as I have to complete the task by today....

  create table candidate(CandidateID Int primary Key, CandidateName Varchar(50))

  Go

  Create table submittal(SubmittalID int, CandidateID Int, BillRate Money, PayRate Money, Notes Varchar(4000) Null, Resume Image, Primary key(SubmittalID, CandidateID))

  Go

  Insert Candidate Values (1, 'Ravi')

  Insert Candidate Values (2, 'Ram')

  Insert Candidate Values (3, 'Ragu')

  Insert Candidate Values (4, 'Ganesh')

  Insert Candidate Values (5, 'Aravind')

  Insert Candidate Values (6, 'Kumar')

  Go

  Insert Submittal Values (1,1,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)

  Insert Submittal Values (2,2,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)

  Insert Submittal Values (3,4,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)

  Insert Submittal Values (4,5,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)

  Insert Submittal Values (5,6,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)

  Insert Submittal Values (6,3,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)

  Go

  I have a proc that searches for all the resumes posted for a specified number of days....

  As the resumes are stored in IMAGE field, it takes around 2 hrs for executing.

  I also tested without the IMAGE field, it took not even a minute....

  Any ideas, greatly appreciated....

  Buddy

  Regards
  Priya