Bob,

Check out this link:
http://ibdeveloper.com/issues/issue-1-sep-1-2005/hyperthreading-smp-and/
<http://ibdeveloper.com/issues/issue-1-sep-1-2005/hyperthreading-smp-and\
/> It advises against hyperthreading on multi-cpu servers.

As for backup/restores, we have had consistent times since we went to FB
classic a while ago. Backups take about 15 minutes and restores about
1.5 hours. We do a sweep before the backup and this can be quite
variable: usually anywhere from about 5 to 20 minutes.

Greg

--- In firebird-support@yahoogroups.com, "Bob Murdoch" <mailgroups@...>
wrote:

>
> Greg,
>
> > -----Original Message-----
> > From: Greg Kay [mailto:gkay@...]
> > Sent: Wednesday, November 22, 2006 12:55 AM
> >
> > Our hardware specs are: dual CPU opteron 252 with 16 Gb ram running
> > SuSE Linux 10.1.
> >
> > Typical usage is about 1 million transactions a day using about 150
> -
> > 200 connections at a time (between 8am and 8pm). The server
> > mostly sits at about 30-40% of capacity.
>
> Does the Opteron have the equivalent of the Intel 'hyperthreading'?
>
> Just curious, how long does it take for the backup/restore cycle on
> your 25GB database? Do you see the backup or restore elapsed time
> being wildly divergent from one day to the next? I've been tracking
> those stats for over a year now, and can't explain what I see. I
> would have expected a gradual increase in each as the database grows
> (accounting for server load, of course), but that is not what I see.
> I've been meaning to bring it up on this list for a while now.
>
>
> Bob M..
>

[Non-text portions of this message have been removed]