Subject | Re: performance problem on Xeon + RAID1+ Windows 2003 server |
---|---|
Author | tjelvare |
Post date | 2008-10-27T15:51:33Z |
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:
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
> .-----------------------------.
>