| Subject | Report queries with FireBird |
|---|---|
| Author | william_yuwei |
| Post date | 2010-10-19T14:53:16Z |
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
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