At 09:40 AM 1/05/2004 -0400, you wrote:

>Thanks Helen
>
>I have one app on the databse server PC and others on a LAN talking to the
>database. Can the app on the db server be using localhost and the others
>connecting using tcpIP and the server name and database path?
>Is it better to remove the app from the db server altogether and just have
>the XPPro pc as a dabase server?
>IB (I think) is causing me problems if an app is on the same PC as the db
>server.

Depends on the sort of problems, I guess. If you have a resource-hungry
local application eating up resources, then it's taking memory that the db
server would otherwise use. Db servers don't need to be particularly fast
but they love RAM. If you take some away and give it to something else,
they won't reward you by running faster. :-)

Order Bys and Group Bys, as well as some joins, should be much faster on Fb
1.5 if you let the server have plenty of mem, because it will try to use
RAM for the sorting.

/hb