Is it generally better to run functions on the webserver, or in the database? eg: INSERT INTO example (hash) VALUE (MD5('hello')) or INSERT INTO example (hash) VALUE ('5d41402abc4b2a76b9719d911017c592') Ok so that's a really trivial example, but for scalability when a site grows to multiple websites or database servers, where is it b...
What, if any, is the performance difference between the following two loops? for(Object o: objectArrayList){ o.DoSomthing(); } and for(int i=0; i<objectArrayList.size(); i++){ objectArrayList.get(i).DoSomthing(); } ...
I have been searching for recent performance benchmarks that compare L2S and EF and couldnt find any that tested calling stored procedures using the released version of EF. So, I ran some of my own tests and found some interesting results. Do these results look right? Should I be testing it in a different way? One instance of the conte...
I have been looking at improving my asp.net page performance, is it worth changing autoeventwireup from true to false and adding the event handlers or is the performance penalty very small? This is an asp.net 2.0 project. ...
I wonder if the UNIX domain socket connections with postgresql are faster then tcp connections from localhost in high concurrency rate and if it does, by how much? ...
I created an html helper Html.BreadCrumb(IDictionary<string, string> crumbs) Where the first string is the label and the second string is the URL. The helper creates the html required (an unordered list, some classes for first element, current element, last element, dead element and separators etc) All working nice, but I do this by ...
I think many developers know that uncomfortable feeling when users tell them that "The application is slow (again)." In a complex web application there can be many possible reasons for a degradation in (perceived) performance: slow database response, bandwidth issues, bad caching etc. There certainly are issues which will never occur in...
A Java web application that I'm working on requires that I restart the server fairly often in order to see the effects of my code changes. I have a local version of WAS 6.0 on my machine that I use to run the app. The server takes about 5-10 minutes to restart. My machine is pretty decent with a dual core proc and 3 GBs of RAM, but the...
I have to simultaneously load data into a table and run queries on it. Because of data nature, I can trade integrity for performance. How can I minimize the overhead of transactions? Unfortunately, alternatives like MySQL cannot be used (due to non-technical reasons). ...
I have written a small java application for which I need to obtain performance metrics such as memory usage, running time etc., Is there any simple to use performance measurement tool available? ...
I need to be able to insert/update objects at a consistent rate of at least 8000 objects every 5 seconds in an in-memory HSQL database. I have done some comparison performance testing between Spring/Hibernate/JPA and pure JDBC. I have found a significant difference in performance using HSQL.. With Spring/Hib/JPA, I can insert 3000-400...
I'm currently writing a C# application that does a lot of digital signal processing, which involves a lot of small fine-tuned memory xfer operations. I wrote these routines using unsafe pointers and they seem to perform much better than I first thought. However, I want the app to be as fast as possible. Would I get any performance benef...
I'm wondering how slow it's going to be switching between 2 databases on every call of every page of a site. The site has many different databases for different clients, along with a "global" database that is used for some general settings. I'm wondering if there would be much time added for the execution of each script if it has to conn...
I've been having performance issues with a high traffic ASP.NET 2.0 site running on Windows 2000. While editing the web.config file I noticed that the authentication mode was set to 'Windows'. I changed it to 'None'. The only users this site has are anonymous and it gets 25,000+ page views at day. Could this have been a caused perfor...
I'm trying to squeeze some more performance out of my rendering pipeline. The (by far) slowest part is performing a java.awt.imaging.LookupOp on a large image. The image size is about 2048x2048. I have figured out that having the filter done along with the drawing operation is much faster than calling the filter method. However thi...
.Hw we can improve the performance of ssrs report..Its taking huge time to execute the report.We implement paging in SSRS...but its not effective...... Any body can help on this matter..... ...
If something is making a single-thread program take, say, 10 times as long as it should, you could run a profiler on it. You could also just halt it with a "pause" button, and you'll see exactly what it's doing. Even if it's only 10% slower than it should be, if you halt it more times, before long you'll see it repeatedly doing the unnec...
Hi, Is there any performance difference between the for loops for primitive array? Assume double[] doubleArray = new double[300000]; for (double var: doubleArray) someComplexCalculation(var); or for ( int i = 0, y = doubleArray.length; i < y; i++) someComplexCalculation(doubleArray[i]); Test result I actually went and...
Is there any performance reason to declare method parameters final in Java? As in: public void foo(int bar) { ... } Versus: public void foo(final int bar) { ... } Assuming that bar is only read and never modified in foo(). ...
Hi, Any suggestions on how to improve DataGridViewComboBoxColumn performace with large item sets? I've got a DataGridView with several columns of type DataGridViewComboBoxColumn. I'm databinding those combobox columns to a rather large collection (10k+ items). As a result it's very slow to display the items (when i click on the down-ar...