Very slow restore from gbak containing a huge small blobs via classic
---------------------------------------------------------------------
Key: CORE-5653
URL: http://tracker.firebirdsql.org/browse/CORE-5653
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial
Environment: Classic server on Linux
Reporter: Roman Simakov
The problem is that time or restore more then 100x via classic comparing to
super. The problem appears if I restore an backup made by gbak via connection
to classic server with its own listner. If I run super, superclassic or direct
connection without network layer all work good. There is no load neither disk
not CPU.
I found that TCP_NODELAY socket option is not set for classic listen socket. It
set only in Super modes. However it must be set since severl socket options are
interited from listen socket. It's described for example here:
https://notes.shichao.io/unp/ch7/#checking-if-an-option-is-supported-and-obtaining-the-default
Moving setting this option out of a condition solves the problem.
On Windows it works find without changing. I'll prepare a patch only for Linux
right now.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
