Some 245,500 investigations were shelved by police before a suspect was identified, figures show.