Have you tried running _YOUR_ processes against postgre and mysql for
comparative stats? I am sure that many of us would be interested in the
results, and then trying to tear them apart to understand what they
mean.

If memory serves me correctly, python has a transparent interface
library that connects to various databases.

Does anyone familiar with the python drivers for Firebird know if the
parameterized queries are built as strings and prepared on every
invocation or they are prepared once and the paths re-used?

On Thu, 2005-07-14 at 14:17 +0000, Maurice Ling wrote:
> --- In firebird-support@yahoogroups.com, "Simon Carter"
> <simon.carter@t...> wrote:
> > > -----Original Message-----
> > > As a side note - even "real databa$e $erver$" are CPU hungry. Just
> > > because you pay lot$ of dollar$ for MS-SQL, Oracle, or DB2 does
> not mean
> > > your code will use less CPU.
> >
> > Firebird is a real RDBMS ;-)
> >
>
> I know that but definition and history is irrelevant when faced with
> numbers to explain.
>
> > >
> > > RDBMS are, by definition, CPU hogs.
> >
> > I would hazard a guess that 99% of CPUs in the world are under utilized,
> > including (in my experience at two large web hosting companies) most web
> > based servers. IMO its not a bad thing that a CPU is hitting 99 - 100%
> > utilization (with the exception of power consumption) and any user
> that has
> > a copy of M$ Office will notice that 100% CPU is used by Excel, Word
> etc.
> >
> > I would have thought the thread priority of an application/server
> process is
> > more of an issue, to ensure one process doesn't unnecessarily block
> another
> > processes from getting a fire slice of the CPU.
> >
>
> I am the only person using FB. In fact, I "forced" the system admin to
> install it for my usage. So, 3 scripts running eats up 3 full CPUs'
> processing capabilities. If database servers MUST run at that power, I
> am then faced to answer the question "why isn't processes by mysql
> user (mysql processes) or postgres user doing the same?" Unable to
> explain means change a database engine.
>
> High CPU usage matters when a total of 100 processes or scripts are
> running at the same time by various users and people are complaining
> that their scripts took longer to run after Maurice and his Firebird
> comes into picture.
>
> Most of the users on the system have scripts which takes weeks to run.
> So a 10% decline in performance can mean days. Currently I am running
> a script that should be completed just in time for Chistmas.
>
> Cheers
> Maurice
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>