Which Firebird connection protocol should be fastest?
I have Delphi DataSnap aplication connected to Firebird 2.5 database at the same computer, runing on Windows.
Which protocol is fastest: TCP, named pipe or XNET.
For backup I am using gbak with "-se service_mgr"
and that is more than twice faster in compare to gbak without -se
. Does any of protocols work like gbak's "-se service_mgr"
?
This example is without -se
"C:\Program files\Firebird\Firebird_2_1\bin\GBAK" -b -v -limbo -ignore -garbage 127.0.0.1:c:\baze\baza.fdb c:\baze\baza.gbk
This example is with -se
"C:\Program files\Firebird\Firebird_2_1\bin\GBAK" -b -v -se service_mgr -limbo -ignore -garbage 127.0.0.1:c:\baze\baza.fdb c:\baze\baza.gbk