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 >