performance

How to optimize this low-performance MySQL query?

Hi there, I’m currently using the following query for jsPerf. In the likely case you don’t know jsPerf — there are two tables: pages containing the test cases / revisions, and tests containing the code snippets for the tests inside the test cases. There are currently 937 records in pages and 3817 records in tests. As you can see, it t...

Even using sgen on my service class still results in agonizingly slow constructor

Hi all. So I'm trying to speed up our applications startup times -- and I've identified a major bottleneck to work on. Each of our webservice client classes takes forever and a day to instantiate. Some investigation revealed this is entirely due to the SoapHttpClientProtocol running GenerateXMLMappings. I started searching for inform...

WURFL on App Engine

I'm trying to implement mobile browser detection in appengine, using WURFL. However, it appears to be impossible to implement it w/o causing a crazy amount of CPU usage, as well as page loading latency. Any ideas on how I can speed it up? ...

What is the danger in simply increasing the Connection Pool?

I'm doing some performance testing against an Apache server and getting the dreaded message "the context pool has been exhausted! Dun Dun Dun." (dramatic emphasis added) The current proposal floating around by the devs is to simply increased the connection pool-size. While this may be valid, little bells are going off in my head saying...

Background application profiler / real work benchmark

I've been thinking of creating an application that sits and waits for process start, and after that times how long it takes before an event such as window activation happens. I'm interested in measuring real time performance of applications. Over time, as more and more software is loaded onto a machine, the machine becomes progressiv...

Advices on time-consuming procedure in C#

I've developed a program using Delphi that, among some features, does a lot of database reading of float values and many calculations on these values. At the end of these calculations, it shows a screen with some results. These calculations take some time to finish: today, something like 5 to 10 minutes before finally showing up the resu...

Performance profiling of Windows Apps. Better alternatives for Visual Studio Profiler?

I am impressed with Visual Studio Profiler for performance analysis. Fast for my purposes and easy to use. I am just curious to know about the caveats in visual studio profiler. Are there any better profilers for windows applications which fare better for these caveats? ...

[Oracle] Which select Statement has better performance ?

Suppose master_table contains many records and both the "id" field of the master_table, tableA,tableB,tableC and tableD are the same in the business sense. For the 2 select statements shown belows , Will they both return the same result set? Which one will have better performance ? I think if both tableA_tmp ,tableB_tmp,tableC_tmp ...

IIS performance improvements

What can be done to improve performance in IIS? When I deploy my webapplication to my local IIS machine it goes much slower than when I run the solution in visual studio without debugging. The difference is remarkable, like double as fast. ...

What is an efficient way to do pattern match in MySQL?

We have a huge pattern match in a query (about 12 strings to check). Now I have to do this query in MySQL, but it seems that the query from PostgreSQL has not the same syntax. From PostgreSQL: SELECT value FROM ... WHERE ... AND `value` !~* '.*(text|text2|text3|text4|text5).*'; How do I do this in MySQL in a efficient way? ...

Most efficient way to visit nodes of a DAG in order

I have a large (100,000+ nodes) Directed Acyclic Graph (DAG) and would like to run a "visitor" type function on each node in order, where order is defined by the arrows in the graph. i.e. all parents of a node are guaranteed to be visited before the node itself. If two nodes do not refer to each other directly or indirectly, then I don'...

Read/Write File vs. Query Database

My website has a large number of readers every day. I wanted to track the traffic of each article. For each visitor, I added a unit on the counter. I'm confused between two solutions: Saved to a file on the server. Create the cron jobs to update them on the database. Save directly to database. Should I do now? ...

Can i use datacontracts in WCF for streaming

Hello Experts, Please can i use datacontracts in WCF for streaming instead of message Contract. If yes, will it offer any performance improvement? THanks ...

Does the size of a jar file affect the performance of the JVM?

I was wondering if the size of jar file has any implications for the peformance of the Java Virtual Machine? Is there going to be a point where the jar file becomes too large that the JVM will not be able to function effectively? ...

Browsers, do they treat a random query string as a different file?

If I set a far future expire header for this file (take note of the query string): /css/getCSS.php?v=1284532156.css Will it treat the entire URL (including the query string) as a single file and respect the expire deceleration, but request the next version of the file... /css/getCSS.php?v=1284599999.css ...from the server as it won...

PHP / Wordpress - get http requests from a page

Hi I have a test wordpress intallation on localhost and recently I noticed the administration pages load very slow. Everytime I'm connected to the internet and open the /wp-admin pages it takes 14-15 seconds to load. This does not happen in the front end. Is there any way to get info about all the http requests that are being made in t...

Running JAVA on Windows Intel vs Solaris Sparc (T1000)

Hi I'm trying to test my JAVA app on Solaris Sparc and I'm getting some weird behavior. I'm not looking for flame wars. I just curious to know what is is happening or what is wrong... I'm running the same JAR on Intel and on the T1000 and while on the Windows machine I'm able to get 100% (Performance monitor) cpu utilisation on the Sola...

How does Silverlight web browser application performance affected by number of pages or child pages in application?

If you have practical experience deploying Silverlight image viewing and deep zoom applications, does number of application pages affect performance? Let's say download or execution time, display time, etc. The need is to prvide users with a lot of dedicated interfaces to view and process images including deepzoom images. What is bette...

Why would a Stored Procedure run slower than naked T-SQL?

I have a stored procedure in a MS-SQL 2005 database that: Creates two temp tables Executes a query with 7 joins but is not otherwise terribly complex Inserts the results into one of the temp tables Executes two more queries (no joins to "real" tables) that puts records from one of the temp tables into the other. Returns a result set fr...

Is type hinting helping the performance of PHP scripts?

Hello there, Type hinting helps the compiler to assume the type of the variable, but, as the PHP is a dynamic scripting interpreted language, the question came to my mind if it's possible that type hinting even makes the runtime faster or not? ...