Bogusław Brandys wrote:

> Martijn Tonies wrote:
>
>>>>>>Is this possible that installing Firebird SS server 1.5.2 on Windows XP
>>>>>>caused other program that is using MSSQL over ODBC to slowdown fetching
>>>>>>data from MSSQL server ? I'm surprized but that's what my customer said
>>>>>
>>>>>:-(
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>Anyone had such problem?
>>>>>
>>>>>
>>>>>I guess that if Fb is busy switching CPUs on a multi-CPU system, or
>>>>>that if there's a .gdb database being "system restored" or if Fb is busy
>>>>>in any kind of way, then yes, it could.
>>>>>
>>>>>But "just" installing it? I doubt it.
>>>>
>>>>
>>>>
>>>>
>>>>Maybe hyperthreading ? Could this harm performance just by installing
>>>>? I suspect that it is Pentium IV inside.
>>>>On the other way if I switch it off in BIOS ,that could down performance
>>>>for other applications, right ?
>>>>Does default installation has CPUAffinity correctly set or I must change
>>>>it manually ?
>>>>Please help.IT staff or my customes said that Firebird is causing such
>>>>problems even if it's running on background without any clients
>>>>connected.I rather desperate want to exclude such possibility ! :-(
>>>>Could it be related to "CPU goes to 100%" bug in Firebird 1.5.2 ?
>>>>
>>>>Regards
>>>>Boguslaw Brandys
>>>
>>>Additional note :
>>>Long report for MSSQL is completed after 35 minutes when Firebird
>>>service is disable and after more then 60 minutes when Firebird is
>>>running (as IT staff said).
>>
>>
>>Firebird isn't doing anything? Or is it in use?
>>
>>
>>
>>>How can I change instalation of SuperServer into ClassicServer without
>>>uninstalling it (I have changed aliases.conf and firebird.conf and would
>>>like to preserve them) ? Could it be solution for my problem ?
>>
>>
>>Copy the two files to a safe place, then uninstall, install Classic and
>>copy the two files back in place.
>>
>>
>>
>>>I appreciate any help.This is very annoying that I must prove Firebird
>>>comapatibility with other programs :-(
>>
>>
>>
>>With regards,
>>
>>Martijn Tonies
>>Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
>>Server
>>Upscene Productions
>>http://www.upscene.com
>>Database development questions? Check the forum!
>>http://www.databasedevelopmentforum.com
>
>
> Thank you for kind reply :-)
>
> One more question : I replaced standalone server with embedded to be
> sure that when my program is not working it does not harm MSSQL :-(
> , but caould I be sure that when closing my program fb embedded is also
> closed even if my import utility was done a huge delete operation on
> some table inside firebird database ? I set sweep interval to zero.
> Remember : i must be sure to not blame Firebird !
>
>
> Regards
> Boguslaw Brandys

OK.Here are results or replacement of SuperServer with FB embedded :

query (in another client application) against MSSQL done over ODBC is
now twice faster then before (when my program is not running).

It's now almost sure that installing Firebird SuperServer can harm
overall performance in that case.Hyperthreading is main suspect of doing
this ,but still not confirmed.I love Firebird so that is sad new for me
(and I was attacked personally by IT stuff due to instalation of FB
server) :-(
Once again please confirm if HT could really give such big overall
slowdown ?

Regards
Boguslaw Brandys