🚀 go-pugleaf

I have a Table T_EMPLOYEE_GENERAL which i want to combine with a stored
procedure SP_EMPLOYEE_WORKPOINTSHISTORY.
The stored calculates the sum of points the employee has worked during
certain period grouped by Employee and Date.

The stored procedure itself takes about 1 second to calculate as does the
retrieval of the employees.
The table contains about 30 Employees who do about 30 jobs (for the point
count) a day.
Still the following query takes about 15 seconds to finish.

SELECT
  EG.EG_EMPLOYEEID,
  EG.EG_EMPLOYEEFULLNAME,
  EWPH.EWPH_WORKPOINTS
FROM
  T_EMPLOYEE_GENERAL EG
  LEFT JOIN SP_EMPLOYEE_WORKPOINTSHISTORY(1, 'SEP-26-2007','SEP-26-2007')
EWPH
    ON (EG.EG_EMPLOYEEID = EWPH.EWPH_EMPLOYEEID)
WHERE (EG.EG_EMPLOYEELOCATIONID = 1)


Stored Procedure:

CREATE PROCEDURE "SP_EMPLOYEE_WORKPOINTSHISTORY"
(
  "LOCATIONID" INTEGER,
  "WORKDATEFROM" DATE,
  "WORKDATETILL" DATE
)
RETURNS
(
  "EWPH_EMPLOYEEID" INTEGER,
  "EWPH_WORKDATE" DATE,
  "EWPH_WORKPOINTS" INTEGER
)
AS
BEGIN
  FOR
    SELECT
      GH_EMPREADY,
      GH_DATEREADY,
      SUM(GH_POINTSINV)
    FROM
      T_BASKET_GENERAL_HISTORY
    WHERE
      (GH_READYOK = 1)
    AND
      (GH_SCREADY = :LocationID)
    AND
      (GH_DATEREADY >= :WorkDateFrom)
    AND
      (GH_DATEREADY <= :WorkDateTill)
    GROUP BY
      GH_EMPREADY,
      GH_DATEREADY
    INTO
      EWPH_EMPLOYEEID, EWPH_WORKDATE, EWPH_WORKPOINTS
  DO
  SUSPEND;
  END

Olivier Peter