Re: [SQLObject] Firebird updates

[James R. <jcr...@ya...>]

--- 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