Subject | Re: [firebird-support] Re: performance problem on Xeon + RAID1+ Windows 2003 server |
---|---|
Author | tjelvar eriksson |
Post date | 2008-10-27T17:04:51Z |
I'm glad to hear that You don't agree. Maybe You can give me some help
regarding my UTF8-collation questions.
Regarding affinity and fbconf, read it as an effort to help... even
good brains break
down from time to time...
27 okt 2008 kl. 17.48 skrev Alan.Davies@...:
regarding my UTF8-collation questions.
Regarding affinity and fbconf, read it as an effort to help... even
good brains break
down from time to time...
27 okt 2008 kl. 17.48 skrev Alan.Davies@...:
> I can't agree with your comments.. Most people are ready and willing[Non-text portions of this message have been removed]
> to help.
> Have you tried to get answers to MS Sqlserver problems?
>
> Server config settings are well documented and if a user plans to
> install on a raid-based Xeon server you'd hope that he/she would be a
> serious user and therefore be aware of affinity masks and the like. If
> you download from the Ibphoenix site the docs are all there.
> I have 8 or 9 dual P3 and P4 machines, and 4 dual Xeon machines with
> superserver installed and they all perform very well.
> However, its hard to give specific answers to general questions, so if
> Fab10 gives us some detail of the selects or stored procedures he's
> running I'm sure "someone" will help.
>
> --
> Alan J Davies
> Aldis
>
> Quoting tjelvare <tjelvare@...>:
>
> > Guess you're familiar with the affinity mask in fbconf ?
> >
> > fb may run slower on dualcore.
> >
> > to improve report further, use triggers or similar to avoid lookups
> > in tables at
> > "end of branches", (use triggers to copy the lookup-value to the N-
> side.)
> >
> >
> >
> >
> > Furhermore, I'm really excited about the positive glow and
> > commitment in this forum....
> > (not).
> >
> > Why oh why.. fb needs better support and docs, but nothing is all
> > thats happening around
> > here...
> >
> >
> > --- In firebird-support@yahoogroups.com, "Codebue Fabio - P-Soft"
> > <f.codebue@...>
> > wrote:
> >>
> >> I have installed my apps on a Acer server with these caracteristics
> >>
> >> . Processor: 1 x Intel Xeon - 3.0 GHz - DC
> >> Ram: 2 GB
> >> Cache: 6 MB
> >> Hard disk: 2 x 80Gb S-ATA 7200rpm
> >> Controller: S-ATA con RAID LSI
> >> . windows 2003 server SP2
> >> . Firebird 2.0.3 - Superserver standard firebird.conf
> >>
> >> Using win performance monitor I have these situation
> >> 80/90 % hard disk time
> >> 5/8 £ processor time
> >>
> >> my statistic program need 6min to complete
> >>
> >> insall the same firebird server on a Windows xp machine my
> statistic program
> >> need 1min to complete!!!!
> >>
> >> are there some parametrer to increase performance?
> >>
> >>
> >>
> >>
> >>
> >> fab10
> >> .-----------------------------.
> >>
> >
> >
> >
> >
>
>
>