Try updating 2.1.4.18357
The truth that I have not presented that problem, do you use indexes for the select?

Regards
=========
|| ISMAEL ||
=========

----- Original Message -----
From: william_yuwei
To: firebird-support@yahoogroups.com
Sent: Tuesday, October 19, 2010 10:53 AM
Subject: [firebird-support] Report queries with FireBird



HI, All

Report queries (built with stored procedures) are always time consuming and resource haunters, I'm just wondering how you guys manage your report queries that working well and don't interrupts others. We are using FireBird 2.13 superserver under Window 2003 (one CPU affinity), Every time when some ones try running reports, its just slowing down others. so I'm thinking to have 2 mirroring servers, one for main database, and one just for the reporting purpose, is it doable? Anyone has any good ideas/recommendations?

Regards,

William





[Non-text portions of this message have been removed]