Subject RE: [firebird-support] Re: Scale or tune firebird?
Author David Johnson
More CPU's are not always a waste for a single threaded process - one
CPU to handle the OS, and one to handle your app is a prime example.

A lot of serialized processes can be pipelined through queue's and made
multi-threaded - I have one I am working on right now to transfer a few
hundred gigabytes from a legacy database to a purchased third party
product. It is serialized, but its very serialization suggests a
multithreading structure that quadruples its throughput on a single CPU
machine.

The 64 bit box with a SAN that I suggested is guaranteed to improve
performance, but it may not achieve the results he is looking for.

Without details, anything we say about Robert's process is just a guess.

On Thu, 2004-11-11 at 00:33, Nigel Weeks wrote:
>
> Hi Helen,
>
> What's going on with this guy?
> If you've got a single process, running a serialised tasks, more CPU's are
> just gonna waste time...or not?
>
> Perhaps I should just sit back and watch...
>
> Nige.
>
> >
> > Thank you David,
> > This is the type of responce we needed.
> > The problem with the task we are doing is that it is HUGE.
> > It takes lots of minute steps that each take microseconds,
> > but they add up to hours/days and they need to be done
> > in sequential order.
> >
> > Regards,
> >
> > Robert.
> >
> > --- In firebird-support@yahoogroups.com, David Johnson
> > <d_johnson@c...> wrote:
> > > I think we need more info to provide meaningful feedback.
> > >
> > > If the bottleneck is really at the hardware level, then you want to
> > go
> > > to at least a 64 bit Opteron box with gigabit SAN connectivity and
> > as
> > > many CPU's as you can profitably use.
> > >
> > > If your process is queueable and you are running a multi-CPU box
> > then
> > > running the receiving process on a separate thread from the write
> > > process will allow the queue to buffer spike loads and maximize
> > > throughput
> > >
> > > What throughput are you experiencing? What hardware do you currently
> > > have?
> > >
> >
> >
> >
> >
> >
> >
> > ------------------------ Yahoo! Groups Sponsor
> > --------------------~-->
> > Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> > Now with Pop-Up Blocker. Get it for free!
> > http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> > --------------------------------------------------------------
> > ------~->
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>