Subject | Re: Firebird Usage Load Problem |
---|---|
Author | Maurice Ling |
Post date | 2005-07-14T14:01:40Z |
>being
> Nope. Haven't heard a dicky-bird about what the database server is
> asked to do, or how intensively it's being asked to do it.should show
>
> I'm baffled, though, as to why you think your Python client script and
> (unspecified) operations being executed by Fb server processes
> up with roughly equal CPU usage. Can you give *us* any insights onthis
> subject? What's your script telling the database to do? Do theseI sense some defensiveness......
> operations ever finish? etc., etc.
>
> ./hb
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