[
http://tracker.firebirdsql.org/browse/CORE-3560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Leyne reopened CORE-3560:
------------------------------
Re-opened based on comments and additional details received.
> 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
> Assignee: Alexander Peshkov
> Fix For: 2.5.1
>
> Attachments: Database.rar, MemoryUsageWindows.docx, metadata.rar,
> Multiconexion.rar, ResourceMonitor.png, TaskManager.png, TaskManager.png,
> UDFCointec.dll
>
>
> 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
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
