|
Yes, open and close it, don't dispose of it.
RobCroll wrote: Use using, create the connection, command and parameters
Absolutely not.
|
|
|
|
|
There is not one answer because it depends on what your app is doing - having said that here are 3 things I have learnt from experience.
(1)If you do not need to refresh or send information to a form then don't - screen refreshes are expensive.
(2)If you can sleep a thread then do - looping though a thread waiting for something to happen is expensive.
(3)With reference to 2 above - make your application as event driven as you can so that you are never waiting for something to happen.
Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
|
|
|
|
|
|
Hi,
We need frequent data updations in real time updating application like online treading and like these others. I will suggest you to go for dapfor .net grid which is capable in real-time data processing like real-time data updating, real-time data highlighting, real-time data sorting and real -time data filtering.
Cheers,
|
|
|
|
|
Over 52 MILLION Google results for ".net performance best practices"[^]
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997
|
|
|
|
|
Hi,
I want to know, what are the major factors which effect our application performance, including all or any.
|
|
|
|
|
Badly written code. Lack of knowledge.
|
|
|
|
|
You forgot not enough homework
P
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|
|
1. Bad design.
2. Bad programming.
3. Inefficient hardware.
"The worst code you'll come across is code you wrote last year.", wizardzz[ ^]
|
|
|
|
|
Poor architecture and rigid development environments.
Poor architecture speaks for itself. If the architect gets it wrong, no number of builders will fix the problem, the house is going to fall down.
Also rigid development environments mean developers are put in there place and not given the freedom to refractor the code.
An example I clearly remember was a situation where a number of methods were passing many parameters and requesting the same data multiple times. By encapsulating the parameters, the methods became a lot more maintainable and only had to do the work once. This is not something an architect is in a position to envisage.
Senior developers need the freedom to pull on the cowboy boots from time to time. They also need to keep an open mind and an open door to junior developers.
"You get that on the big jobs."
|
|
|
|
|
RobCroll wrote: pull on the cowboy boots
To squash bugs in the corners?
|
|
|
|
|
RobCroll wrote: An example I clearly remember was a situation where a number of methods were passing many parameters and requesting the same data multiple times. By encapsulating the parameters, the methods became a lot more maintainable and only had to do the work once. This is not something an architect is in a position to envisage.
And by doing only that by what percentage was the performance of the application reduced?
|
|
|
|
|
 It didn't reduce performance, it improved it. Didn't benchmark the change but it reduced requests to the database by approx 66%
"You get that on the big jobs."
|
|
|
|
|
Requests?
Not sure I undestand that. If I call a proc with one param or 50 the proc call itself is still singular. Now in might be that the driver uses more IP packets for more parameters but if that is significant then one might look for another driver and even another database. And certainly one would reduce all procs to use a minimal number of params or none. So in that case it would not be a lot but rather that it was using any at all.
|
|
|
|
|
Can't really give a code snippet but to give an idea
call ClassLib1.DoStuff(a, b, c, d)
getData e, f, g, h.
call ClassLib2.DoMoreStuff(a, b, c, d, e)
getData i, j, k, l.
call ClassLib3.EvenMoreStuff(a, b, c, d, e, f)
getData i, j, k, z
So instead:
aClass = new aClass()
ClassLib1.DoStuff(aClass)
getData e, f, g, h.
call ClassLib2.DoMoreStuff(aClass)
getData i, j, k, l.
call ClassLib3.EvenMoreStuff(aClass)
getData z
Now you can start avoiding hammering resourses and for me at least, ClassLib3.EvenMoreStuff(a, b, c, d, e, f, z) is not the most maintainable code.
Hope that makes sense
"You get that on the big jobs."
|
|
|
|
|
Looks like a reduction in replicative data retrieval in proc chains.
That has nothing to do with the number of parameters however.
|
|
|
|
|
But after any code performance some other things also matter like :
put huge data into session like multiple tables.
And all the repeated images which I want to show on our application, may not be done cached.
|
|
|
|
|
In general.
1. Requirements - most impact
2. Architecture
3. Design
4. Implementation - least impact
For some limited domains there can be differences in the above. For example embedded device drivers could see performance impacts due to the last item.
|
|
|
|
|
Hello,
If we talk about real time we can perform various data processing in real time like data updating, data highlighting, data sorting, data filtering and data grouping which is application based. I will suggest you a custom component, which will help you to increase your application performance http://www.dapfor.com/Feature.aspx?id=performance[^]
|
|
|
|
|
i try to pass data (string) from terminal (windows mobile) to webservice
i have good connection and i got this error:
Could not find resource assembly
thanks in advance
|
|
|
|
|
You sure that is the complete exception message? It should tell you clearly about which assembly is missing. All you need to do then is figure out why and fix it.
"The worst code you'll come across is code you wrote last year.", wizardzz[ ^]
|
|
|
|
|
i have 5 strings and i need to insert them to dataset.
i dont work with any database, i only need to insert 5 strings to dataset.
how i can do it ?
|
|
|
|
|
What kind of dataset? 5 strings in one row? 5 rows of one string each?
Maybe this link[^] has everything you wanted to know and more...
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://www.codeproject.com/script/Forums/Images/coffee.gif)
|
|
|
|
|
You need to insert 5 strings as 5 rows and 1 column or 5 columns and 1 row?
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.
www.cacttus.com
|
|
|
|
|
Put them in a DataTable first?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
