> This may seem like a very naive question, but is it possible to edit
> the SQL of a trigger from within a programming language (Delphi, in
> my case).
> I use IBX components (I know this is not supported, but it seems to
> work fine!), and I want to periodically update the date condition on
>
Hiyes, slowdown is because of sort as engine must sort the table first and then
retrieve 10 records.But you can try to speed this up by:SELECT FIRST 10 SKIP 0
msg.OBJ_GUID AS "MSG_GUID", msg.PRTY, msg.TTL, pst.OBJ_GUID AS "PST_GUID",
pst.MSTB_DTSFROM (Select * from MSGS m order by m.PRTY)