Firebird 2.5 Classic Server uses 47% more memory than 2.1.5 when caching
metadata
---------------------------------------------------------------------------------
Key: CORE-3560
URL: http://tracker.firebirdsql.org/browse/CORE-3560
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.0
Environment: Windows family
Reporter: Jesus Angel Garcia Zarco
When the user connects to my application, executes one stored procedure to
register the user login. This stored procedure update one table that force the
load of most of the metadata in memory.
The difference is that while Firebird 2.1.5 uses 57100 Kb, Fb 2.5.1 uses 84100
Kb, that is a 47% more memory than 2.1. once executed the procedure and
starting to work with the application, the memory consumption increases in
parallel. That implies that for 200 users the less memory needed for 2.5 is
near 16 Gb, while for 2.1 is near 11 Gb that is a big difference.
That implies that classic server will use per connection so much memory. I
don't know if is a bug or not, but the difference is so much. If classic server
is for complex enviroments with high load, then
Steps to reproduce the issue: Connect to the database and execute procedure
usuario_entrada( 0, '', 'STATION01', '' )
--
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
------------------------------------------------------------------------------
10 Tips for Better Web Security
Learn 10 ways to better secure your business today. Topics covered include:
Web security, SSL, hacker attacks & Denial of Service (DoS), private keys,
security Microsoft Exchange, secure Instant Messaging, and much more.
http://www.accelacomm.com/jaw/sfnl/114/51426210/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
