Re: [SQLObject] Firebird updates

[david <da...@su...>]

Ian,

> Firebird is really slow for me.  Like, the tests take seven minutes to 
> run, compared to 3sec for Mysql, and 9sec for Postgres (MySQL doesn't 
> actually do as many tests).  Are other people getting similar results?  
> I'm *hoping* my Firebird is badly configured, because I'm not that patient.

My guess is that you are using Firebird Classic (a process started by 
init.d for each connection) and the tests are creating lots of 
connections very quickly. If that is the case then init.d or xinetd.d 
can put a limit on the rate at which they will create new processes.

We have had this problem on some machines used by developers.

I am using Mandrake 9.1 which has xinetd (seems to be an improvement 
over init.d) and has this in the firebird description in 
/etc/xinetd.d/firebird

# default: on
# description: Interbase server
service gds_db
{
         flags                   = REUSE
         socket_type             = stream
         wait                    = no
         user                    = root
         log_on_success          += USERID
         log_on_failure          += USERID
         server                  = /opt/interbase/bin/gds_inet_server
     disable         = no
}

I think the wait value is probably the critical one.

Sorry I can't remember how we fixed it on init.d

Dave
-- 
David Warnock: http://davew.typepad.com/42  |  Sundayta Ltd: 
http://www.sundayta.com
iDocSys for Document Management. VisibleResults for Fundraising.
Development and Hosting of Web Applications and Sites.