sql trace time vs sql management studio sql time

Running into a problem where a scroll select takes up to 4 seconds to run through front end but run same sql in management studio and runs under a second.

here is snippet of trace:

1-108772 13.26.08    0.000000   68: ScrollSelect(2, Record.GVT_JOB, Record.Z_ESS_PAR_ATT_V, Record.Z_ESS_PAR_ATT_V, "WHERE EMPLID = :1 and EMPL_RCD = :2 and EFFDT = and EFFSEQ = :4 ", GVT_JOB.EMPLID, GVT_JOB.EMPL_RCD, GVT_JOB.EFFDT, GVT_JOB.EFFSEQ);

PSAPPSRV.1720 (320)   1-108773 13.26.08    0.000000 Cur#1.1720.DHSCPY RC=0 Dur=0.000000 COM Stmt=SELECT EMPLID, EMPL_RCD, EFFDT, (CONVERT(CHAR(10),EFFDT,121)), EFFSEQ, LASTUPDOPRID, ATTACHSYSFILENAME FROM PS_Z_ESS_PAR_ATT_V WHERE EMPLID = :1 and EMPL_RCD = :2 and EFFDT =