Subject | Re: Firebird 1.5 on muliti processor system? |
---|---|
Author | Adam |
Post date | 2006-09-14T12:22:21Z |
> we have problems with firebird performance if one workstation printsI assume you mean the act of running queries to get the data for the
> reports. In the reports are querys which access the firebird database.
>
> Printing reduces performace of all connected users.
report reduces performance rather than the printing itself?
> We were informed, that the server usese 4 processeors. Could this beYou mention nothing about the server hardware. It takes resources to
> the reason?? Do we use the wrong firebird version?
run queries, and if the I/O subsystem is not up to scratch, then the
performance is not going to just fix itself.
You have not mentioned the Firebird architecture you installed, but
for SMP machines such as this, Classic allows the different
connections to use different processors which can help for CPU bound
queries.
You will probably want to consider the query that is run by the print
job to make sure it has appropriate supporting indices. A 486 can run
a query faster than the latest quad core processors if it uses a
significantly better plan.
Adam