I'm testing different locking schemes for a big table, more than 4 million rows and expected to grow up to 10 million. My experience with SyBase: ALLPAGES, extremely slow BCP (in) and update with a field that belongs to the Primary Key. DATAROWS, fast BCP, fast update for fields in the PK, fastest select. DATAPAGES, fastest BCP and upda...
What language is faster? Java or C++? On web, I have come across a multitude of benchmarks who claim one is faster than the other. And yes, I would also like to know whether these differences do have any significance in application development or not? I am really confused. Please shed some light on this. Thanks. ...
In PHP, when I use the file handler for session storing,does Apache caches the SESSION in memory? If not, would a usage of db storage engine on memory tables (mysql) would be a good idea? ...
Hi, I am making a webapp. I have a fairly basic question about javascript performance. Sometimes I need a global variable to store information that is used the entire time the website is open. An example is a variable called needs_saved. It is true or false to say whether the page needs saved. I might have another variable called is_ie...
We are in the process of anylizing the page performance, i would like to know if we have like 10 images , 2 css , 3 JS files. How is IE 7 , 8 actually how render the content. -> Is it like, it call the resources parllelly or is there any limit on the sequancy it calls all this resources.? Or it has like threds in built which will autom...
Compare synchronized (countList) { while (iter.hasNext()) { Entry<Long, Long> entry = iter.next(); if(entry.getVaue>0) entry.output(); } countList.clear(); } with synchronized (countList) { while (iter.hasNext()) { Entry<Long, Long> entry...
In the old (single-threaded) days we instructed our testing team to always report the CPU time and not the real-time of an application. That way, if they said that in version 1 an action took 5 CPU seconds, and in version 2 it took 10 CPU seconds, that we had a problem. Now, with more and more multi-threading, this doesn't seem to make...
I've got a query which has a WITH statement for a subquery at the top, and I'm then running a couple of CONNECT BYs on the subquery. The subquery can contain tens of thousands of rows, and there's no limit to the depth of the CONNECT BY hierarchy. Currently, this query takes upwards of 30 seconds; is it possible to specify indexes to put...
While trying to reproduce a reported problem with a managed nt-service, I've noticed that the performance counter "# of Methods Jitted" is constantly increasing (together with "# of IL Bytes Jitted"). The reported behavior consists of taking alot of memory (not necessarily everything available on the machine) and consuming 100% cpu. Requ...
How to measure the total memory consumption of the current process programatically in .NET? ...
Hi, I'm currently developping a web site with asp.net that use Lucene.Net to perform fulltext queries. The web site display a couple of data lists. The problem is that i perform fulltext queries FOR EACH items displayed in the list which can be a performance issue. So i wonder if i should "pre fulltext query" with a kind of Search En...
I know SQL server 2005 does some amount of execution plan caching, but would that be enough to create a difference of hours between the same query being run twice? The first time it takes 3 hours the next time it takes 1 min? Is that even possible? ...
I heard a lot about performance problems with jsf (and even asked related question here some time ago). But today I've heard concrete results of jsf performance tests. From the results where jsp showed response time 0-100ms jsf application showed 1000-1200ms. Testing of form submission showed 100-200ms for jsp versus ~1500ms for jsf. ...
In Windows 7(i.e. MSI 5.0), there is a property called MSIFASTINSTALL which will improve the performance of your installer. Or else, you can turn off the rollback option by setting property DISABLEROLLBACK. This property is available in earlier version of MSI 5.0 too. Please share your knowledge to improve the install experience. Also, ...
I am working with a large amount of data: 6 million rows. I need the query to run as fast as possible, but am at a loss for further optimization. I already removed 3 subqueries and moved it from 11+ hours to just 35 minutes on a modest dataset of 100k rows. See below! declare @UserId uniqueidentifier; set @UserId = '936DA01F-9ABD-4d9d-8...
All too often I read statements about some new framework and their "benchmarks." My question is a general one but to the specific points of: What approach should a developer take to effectively instrument code to measure performance? When reading about benchmarks and performance testing, what are some red-flags to watch out for that m...
Hi, I'm developing a web app and during the tests I noticed that sometimes browsers don't load all images (like background or some decorative images) on the website. I need to hit the refresh button to to have it fully loaded. This usually happens when the website is visited for the first time. I suspect that maybe the development serve...
I'm in the process of creating a table and it made me wonder. If I store, say cars that has a make (fx BMW, Audi ect.), will it make any difference on the query speed if I store the make as an int or varchar. So is SELECT * FROM table WHERE make = 5 AND ...; Faster/slower than SELECT * FROM table WHERE make = 'audi' AND ...; or w...
HI all, This is a more general question, but basically I wanna compare the performance of two multimedia software applications. Although they are doing the same thing, they are running on different platforms and also nothing is known about the implementation. I get quite some different performance figures and I am trying to reason about...
The Problem: I want to return all of the rows from the Primary Data table together with the Highest Priority Exception based on the currently assigned Priority in an Exception table. I have created a simplified example of my data set-up below (with creation scripts) so hopefully you can help with what should be a fairly quick T-SQL pr...