Hi,

At December 15, 2005, 11:12 AM, dreezl wrote:

> Early this morning after we tried archiving a lot of the data, we got
> the database file down to just over 1gb. It was still slow, so we
> moved it to the server the applications are on. The performance seems
> back in line with what we were used to; however, I can not keep it on
> this server because the load gets to high and overall performance will
> dip. So, that leads me to believe that it has something to do with
> slow access times to the hard drives. I did some diagnostics on the
> hard drives and nothing came up unusual. Maybe something else is the
> bottleneck? Any ideas or input would be greatly appreciated.

What about the network connection between the two servers? What is
the connection speed between them? How many concurrent connections(on
average) are being made to Firebird?


--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)