What are the difference/changes made in 2.1.4 that you thinks it can help? I
am assuming you are talking about the Superserver, and Yes, Indexes are used
for the selects.

Thanks

William

2010/10/19 Ismael L. Donis Garc�a <ismael@...>

>
>
> 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 <firebird-support%40yahoogroups.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]
>
>
>

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