Hi Alan, thanks for your answer,

My SQL statement is like this :
select a.*, b.nm from T_IN_OT1 a, m_src b
where a.is_cls <> 'T'
and a.id_cst_sppl = b.id
order by a.frm_N desc

Before run this statement, I call stored procedure to calculate stock calculation, it is quiet a heavy procedure.

I am using AMD 6 cores only for testing, because the application is not complex,
and I believe Intel Dual Core E5700 is enough.

I think, on Win7, there is some delay in when retrieved data, could it be I
should change UsePriorityScheduler, PrioritySwitchDelay, and PriorityBoost
parameters in firebird.conf?

Best regards,
Sugiarto

--- In firebird-support@yahoogroups.com, Alan J Davies <Alan.Davies@...> wrote:
>
> Don't think its Firebird. I have applications running on lower
> specification systems with none of these problems, on windows XP, server
> 2003 and on Linux. Also on Win7.
> What is your statement? Are there any parameters or where statements?
> However, if it works on the other syste, why not leave it there?
>
> > Total records is about 5000 data.
> >
> That's not a problem - Firebird would handle this in a blink of an eye!
>
> Alan J Davies
> Aldis
>