Subject Report queries with FireBird
Author william_yuwei
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?