I am running two jobs for Bulk API on FieldPermissions:
SELECT Id, ParentId, SobjectType, Field, PermissionsEdit, PermissionsRead, SystemModstamp FROM FieldPermissions WHERE SystemModstamp <= 2017-05-15T19:58:37Z
SELECT Id FROM FieldPermissions WHERE SystemModstamp <= 2017-05-15T20:30:28Z
Job 1 ran within 15 seconds while Job 2 is slow and running for about half an hour. Same set of job properties that is queried but I don't see why this is taking so long. Tried with SOAP API too for which the query on Job2 is really slow. How to speed up the SOQL on Job 2?