Click here to Skip to main content
15,892,005 members

Comments by Gold$Coin (Top 40 by date)

Gold$Coin 5-Oct-16 2:35am View    
Ya i have tried it. if we do so the executing and all the underling calculation are doing good in reasonable time. But when we bind the data to the UI with all the stuffs in it (Coloring/Allignment/Font Size, Etc.,) it taking to much of time to complete so i decided to do it parallel and i have done with that. but only the Distinct part alone taking too much of time to complete.
Gold$Coin 5-Oct-16 2:32am View    
Ya the database columns are well defined since the project i was working on was an Investment system maintenance. so the tables and stored procedures are good. But the data manipulation was complicated. because we are generating a Heat map kind of thing in the datagrid so we using some complex data comparison. previously when we started working on it we had a huge slowness in our application. and we used many logic and some internal frameworks help to make some what faster (30%) but the slow part was only the Getting distinct table from the actual data table. so i want to optimize that.
Gold$Coin 5-Oct-16 2:26am View    
ya sure will try that.
Gold$Coin 3-Oct-16 1:14am View    
More than 4 Min.
Gold$Coin 3-Oct-16 1:03am View    
The code which i have pasted above was the work what i have done in my application. i need to know any thing i need to optimize with the code to improve my performance.