performance changes and removing the 'active' column from jobs table