Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow performance on culture
Message
From
19/12/2010 21:46:56
 
 
To
All
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
Slow performance on culture
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01493324
Message ID:
01493324
Views:
105
This function, if called numerous time during a transaction, will slow down the process:
        ' Format a value
        ' expN1 Value
        ' expC1 Separator
        ' expN2 Number of decimals
        Public Function GetFormatValue(ByVal tnValue As Double, ByVal tcSeparator As String, _
         ByVal tnDecimal As Integer) As String
            Dim lcValue As String = ""
            Dim loCultureInfo As CultureInfo = Nothing

            ' Based on the language
            Select Case nLanguage

                ' English
                Case 1
                    loCultureInfo = New CultureInfo("en-US")

                    ' French
                Case 2
                    loCultureInfo = New CultureInfo("fr-CA")

                    ' Spanish
                Case 3
                    loCultureInfo = New CultureInfo("en-US")

                    ' Portuguese
                Case 4
                    loCultureInfo = New CultureInfo("en-US")

            End Select

            loCultureInfo.NumberFormat.NumberDecimalSeparator = "."
            loCultureInfo.NumberFormat.NumberGroupSeparator = tcSeparator
            loCultureInfo.NumberFormat.NumberDecimalDigits = tnDecimal

            lcValue = tnValue.ToString("N", loCultureInfo)

            Return lcValue
        End Function
I didn't pay attention to it until now. So far, it was mostly used on request for a few displays on a form. But, when being called thousands of times during a hit, this has a significant impact. I am moving the creation of the object at the application initialization level to have it executed only once and store loCultureInfo into oApp.oCultureInfo.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform