Subject Re: Firebird Usage Load Problem
Author Maurice Ling
>
> Nope. Haven't heard a dicky-bird about what the database server is
being
> asked to do, or how intensively it's being asked to do it.
>
> I'm baffled, though, as to why you think your Python client script and
> (unspecified) operations being executed by Fb server processes
should show
> up with roughly equal CPU usage. Can you give *us* any insights on
this
> subject? What's your script telling the database to do? Do these
> operations ever finish? etc., etc.
>
> ./hb

I sense some defensiveness......

What my script essentially does to get a list of primary keys from A
table using kinterbasdb.cursor.execute() method and roll out as a
Python list using kinterbasdb.cursor.fetchall(). For each of the
elements in the list (primary keys), it is used to pull out a record
in another table for processing and insert the results (usually a few
records) into another table. This process is repeated for about 500k
times.

Yes, all operations finishes. More than a thousand records are
retrieved and processed and many thousands inserted every hour.

Maurice