From: Ian B. <ia...@co...> - 2003-10-01 01:58:08
|
Okay, I've applied some of the things James sent me, and a few other small fixes as well. Interested parties may wish to download the CVS snapshot. These are the bugs that remain: DeleteSelectTest.testSelect, PeopleTest.dynamicJoin: The Cursor unknown error -- some problem with using a connection with two cursors, or something. It happens when an iterator still is using a cursor and you execute another statement. The exact problem I'm not sure of, nor the resolution. ValidationTest: We seem to be getting something other than strings back... some sort of funny string-like object? Doesn't seem to cause actual problems unless we are specifically checking the type. DeleteSelectTest.testNewline (and others): Like SQLite, Firebird doesn't like backslash escapes in string literals. One resolution might be to get rid of backslashes, and not quote anything except ' (as ''). 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. Ian |
From: david <da...@su...> - 2003-10-01 13:36:03
|
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. |
From: James R. <jcr...@ya...> - 2003-10-01 14:19:49
|
> 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 equivalent line for inetd.conf would be: gds_db stream tcp nowait root /usr/interbase/bin/gds_inet_server gds_inet_server James __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com |
From: James R. <jcr...@ya...> - 2003-10-01 13:56:08
|
--- Ian Bicking <ia...@co...> wrote: > DeleteSelectTest.testSelect, PeopleTest.dynamicJoin: > The Cursor unknown error -- some problem with > using a connection with > two cursors, or something. It happens when an > iterator still is using > a cursor and you execute another statement. The > exact problem I'm not > sure of, nor the resolution. I'm not sure if this is the same issue or not, but it seems very similar: http://kinterbasdb.sourceforge.net/dist_docs/usage.html#db_api_optional_unsupported > 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? Although Firebird can be as slow as a turtle with bad knees when doing metadate updates, seven minutes for the tests is excessive. For me, they run in 36 sec. on doze, 9 seconds on Linux (vs. 3 sec and 2 sec for mysql). Are you using SuperServer version or Classic? SS is known to have issues under Linux. This article may help: http://www.ibphoenix.com/a519.htm Also, consider changing/setting a pagesize when you create the database. HTH, James __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com |