Allow to set 'my own' TEMPCACHELIMIT size when connecting to FB rather than use one that is specified in firebird.conf ----------------------------------------------------------------------------------------------------------------------
Key: CORE-3787 URL: http://tracker.firebirdsql.org/browse/CORE-3787 Project: Firebird Core Issue Type: Improvement Affects Versions: 3.0 Initial Reporter: Pavel Zotov We have above 500 connections and only 1/3 of them are those in which real work is doing by users (yet 1/3 are for service purposes like messaging between users and 1/3 - to non-production auxiliary database with some reference data). Appox. 166 connects in which users doing they job often calls huge sorts and this operations comsume server memory. Unfortunatelly, every connect should consume such amount of server memory that is defined by firebird.conf TempCacheLimit sessing (8 Mb by default for CS & SC). It will be very good if a connect can specify TempCacheLimit for his own session time and this value will have higher priority than TempCacheLimit in firebird.conf. -- 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