ansadtkd wrote:

> Could you please suggest some tips to improve Firebird Db performance in application level and Db server level. The Db should handle 100+ eCommerce sites and its back end processes.

Probably better to direct this question to the main support list ;)
http://groups.yahoo.com/group/firebird-support/

Although as a starting point, personally I run the database on it's own
dedicated machine when the load is heavy and have multiple web servers accessing
that directly. One can even cache the slow changing data locally on the web
server, so that only the 'read/write' data is traveling the internal network.

I am assuming that the web side IS PHP? An accelerator such as eaccelarator is
probably the first port of call, rather than just the database side.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php