[PATCH] Performance improvements in fetch of string data --------------------------------------------------------
Key: DNET-452 URL: http://tracker.firebirdsql.org/browse/DNET-452 Project: .NET Data provider Issue Type: Improvement Components: ADO.NET Provider Affects Versions: 2.7.7 Environment: Windows 7 x64, .NET 4.0 Reporter: Valeriy K. Assignee: Jiri Cincura Attachments: after.png, before.png While working on performance improvement in my application, I have founded a bottleneck in FirebirdSql.Data.Client.Common.XsqldaMarshaler.GetString(Charset, Byte[]). After changing: return value.Replace('\0', ' ').Trim(); To: return value.TrimEnd('\0', ' '); I get 4x performance boost. Please, see attached profiler screenshots. -- 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 ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider