--- In firebird-support@yahoogroups.com, "Jerome Bouvattier"
<JBouvattier@I...> wrote:

> Hi again,
>
> Does anyone have a clue about this ?
> Is this a known issue ?
> Maybe I should ask in devel ?
>
> Note that cache isn't involved here. Restarting FB doesn't change

the SP's

> execution speed, be it in a fast or slow scenario.

Jerome, IMO this is still cache effect. Subsequent execution of any
statement always is much faster - first execution fills the cache with
pages needed for this statement and subsequent one don't access hard
drive or make it in much less degree.

Best regards,
Alexander.