[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

Reply via email to