Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimized way to transfer from String to StringBuilder
Message
De
05/02/2014 13:11:33
 
 
À
05/02/2014 13:06:55
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01593079
Message ID:
01593305
Vues:
20
>>Don't think so. The string is only being re-assigned once - I don't think Replace() creates any intermediary strings.
>
>It has been my findings before that manipulating a very large string requires a stringbuilder. This was discovered when I do the parsing here for each message. Some of them contains some very big content and using a string was very too slow.

I was just looking at one replace. For a lot:
        Dim lcString As String = "SELECT Member.FirstName,Test.LastName,Member.Bann,Test.Register,User.Blog,Member.Cie,User.NoProvince, Province.Title_E AS Province,Country.Title_E AS Country,Member.City,Member.NoCountry,Member.Http,Member.LastAccess FROM Member(NOLOCK) LEFT JOIN Province ON Member.NoProvince=Province.Numero INNER JOIN Country ON Member.NoCountry=Country.Numero WHERE Member.Numero=@Numero"
        Dim lcWords() As String = {"Member", "User", "Test"}

        Dim stringBuilder As New StringBuilder(lcString)
        For Each s In lcWords
            stringBuilder.Replace(s + ".", "[" + s + "].")
        Next
        Dim result As String = stringBuilder.ToString()
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform