Bob,

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.

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

>
> Greg,
>
> > -----Original Message-----
> > From: Greg Kay [mailto:gkay@...]
> > Sent: Tuesday, November 21, 2006 1:20 AM
> >
> > We're running Firebird Classic 1.5.3 and have a 25 Gb database with
> > about a million transactions per day. Occasionally we have the
> corrupt
> > index problem you mentioned. We pick this up in our nightly
> > backup/restore process where the backup part will fail. Usually we
> can
> > find the index by running a verbose Backup and checking where
> > the backup fails. When we get the index we delete it, run our
> > backup/restore process, then put the index back.
>
> What are the hardware specs on the server running the database? It
> will be interesting to see how closely they match our server. While
> I'm pretty sure it's not our hardware per se, I'm beginning to think
> it has something to do with the way Firebird interacts with it.
>
> Bob M..
>