Maurice Ling wrote:

>There are a few reasons why my system administrator is agitated.
>
>1. He's a mysql user and is very used to seeing database processes
>using low CPU. So, to that is, why is FB using >90% CPU while mysql is
><10% CPU? If DBMS is by nature of the beast CPU intense, shouldn't
>both be as intense? So what is different here?
>
>2. FB's CPU usage almost never drop and is always so high. Shouldn't
>it be a blip of FB usage, followed by a blip of Python usage, and so
>on? As in FB reads, python process, FB reads/writes...... Shouldn't FB
>is doing nothing when data is out for processing?
>
>3. If Python scripts are using a lot of CPU also, then I can say that
>Python is processing very hard and FB has to keep up the I/O
>processes. In this case, it isn't.
>
>Cheers
>Maurice
>
>

Maurice,

The others pointed a lot of things to be measured and tried to see if
you have a low CPU usage.

I will repeat some of those, that I think is high priority to pin down
the problem.

1.) Profile your application to see how much time it consumes in each part
2.) Execute the same operation outside phyton to see the plans
3.) The database statistics when the server is with 100% CPU load
4.) Use prepared statements (if not used yet) to see how it performs
5.) Try to break up the 870k rows loop in some small steps, it will be
easy to see how much it needs to perform 10k rows for example, as it
could show a long time needed by the fetch all

HTH

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 14/07/2005