Hello (if the question is more appropriate for RackOverflow please let me know) I've setup SQL server mirroring, using 2 SQL server 2005 standard editions. When the application is being stressed, response times increase 10-fold. I've pinpointed this to the mirror, because pausing the mirror shows acceptable response times. What option...
Are there any ways to determine what the differences in databases are that affect a SSIS package load performance ? I've got a package which loads and does various bits of processing on ~100k records on my laptop database in about 5 minutes Try the same package and same data on the test server, which is a reasonable box in both CPU and...
There are so many types of open source testing tools: for performance, functionality, and security testing. My question is, which open source tool (for both web-based and client/server projects) is: Largely used for performance, functionality and security testing Easy to understand Easy to use Acceptable/accepted in interviews Easy to...
I am working a similar problem as Question 222511 I do need to use the MemberInit Expression so I can just add them to the constructor... I am trying to implement John Skeet's answer but I am running into a big performance difference. Here is some of the code: // Method A: // This work good, is fast and returns an un-executed query... D...
Hi all. Just wondering if anyone knows about what performance is like for the WPF Toolkit DataGrid for inserting rows to the top of the visible area. I know that ListBox and ListView will recreate all new visuals for all of the rows that are pushed down, which is a major impact on performance; I was wondering if the WPF Toolkit DataGri...
I have a database infrastructure where we are regularly (at least once a day) replicating the full content of tables from a source database to approximately 20 target databases. Due to the replication code in use (we have to use regular oracle queries, no control or direct access to source database) - this results in 20 full-table sorts ...
We're developing a "Search Reporting" feature for a client. One of the requirements is that they can view a particular result and see which search terms lead to it. Our search_results table is simply a mapping of searches.id to results.id. So we need to do a bulk insert into this table and need to know the fastest way to do this withou...
I am looking for a good explanation of why one would use sliding expiration when caching data in a Web application. It seems as if you would always want to cache content using absolute expiration so the data is forced to be refreshed. With sliding expiration you risk having your data be cached indefinitely. Is it only useful for cachi...
Hi. Lets simply fantasize and talk about performance. As I have read the article in about.delphi.com called performance programming, there was interesting paragraphs claiming that Case statement ( in fact I prefer calling it as structure ) is faster than If ; For is faster than While and Repeat, but While is the slowest loop operator. I...
After migrating my whole setup from Java 1.5 to 1.6 (J2EE, Tomcat) a couple of months ago, I just realized that Maven is still configured to generate class files targeted for 1.5 via Sun's javac parameter "-target 1.5". Can I expect any performance boosts when changing "-target 1.5" to "-target 1.6"? ...
This shell script is used to extract a line of data from $2 if it contains the pattern $line. $line is constructed using the regular expression [A-Z0-9.-]+@[A-Z0-9.-]+ (a simple email match), form the lines in file $1. #! /bin/sh clear for line in `cat "$1" | grep -i -o -E "[A-Z0-9.-]+@[A-Z0-9.-]+"` do echo `cat "$2" | grep -m 1 ...
In PHP, I'm frequently doing lots of string manipulation. Is it alright to split my code into multiple functions, because if primitive types like strings are passed by value I would be significantly affecting performance. ...
I am puzzled. I looked at the trace of a pagecall that was "slow" to load according to my boss, causing the page to partially load, and then "jump" to the memorized scroll-place on a postback. I found out eventually, using my trace, that my whole loading, from Begin PreInit to End Render, took 1.94 seconds, 1.5 of which are spent betwee...
I am considering using an NSMutableDictionary in place of my current NSMutableArray. This is primarily for KVC/KVO reasons. The collection will undergo heavy mutation within the inner loop of my drawing method. Can I expect to incur a significant performance hit if I go ahead with this replacement? Cheers, Doug ...
Dropping my lurker status to finally ask a question... I need to know how I can improve on the performance of a PHP script that draws its data from XML files. Some background: I've already mapped the bottleneck to CPU - but want to optimize the script's performance before taking a hit on processor costs. Specifically, the most CPU-co...
See this screenshot from Firebug's Net tab: I know that: The time between 1 and 2 is the time taken by my app to generate the HTML and for the data to make its way to the browser. The time between 3 and 4 is the time taken by my JavaScript initialization code which runs on DOMContentLoaded. But what about the time between 2 and 3?...
I was reading an article about how query expressions defer executions. Does that mean when we have a collection like: IEnumerable<int> collection = from i in integers where i % 2 == 0 select i; It is gonna be recalculated every time the collection is accessed? If so, what's the general practice to deal with this? To convert into a ne...
My app uses temporary tables in PostgreSQL. With new, 8.4 release I tested its performance compared to old 8.2 release and I observed that temp tables are ten times slower! Test of 8.3 release show that it was slower in 8.3 too. I compared configs of all bases and they are similar. All bases work on the same server. While my app uses JD...
I am wanting to load test a web based application that we are hosting on an IIS server (Windows 2003, IIS 6, PHP 5.2.0, MySQL 5.0.22). What are the best tools for : a) load testing b) catching bottlenecks c) catching memory leaks anything else I should be looking for? thanks ------------------------------ UPDATE ---------------------...
Lee Brimelow got me thinking about my Flash Application CPU and Memory consumption in his blog. So I'm thinking if there is a good (non task manager) tool for performance testing? ...