Performance of Oracle's dbms_crypto.hash function for SHA-1
Looking for stats for input sizes of at least between 4 and 30 MB. ...
perfomance
How to increase PHP over HTML speed?
I have a PHP file that gets HTML from Memcached and serves it to user. When I test it like this: ab -n 1000 -c 100 http://website.com/test.php It does 22 requests per second. But when I put the same HTML to a html file and do this test: ab -n 1000 -c 100 http://website.com/test.html I get like 4500 requests per second. I n...
Is object-oriented PHP slow?
I used to use procedural-style PHP. Later, I used to create some classes. Later, I learned Zend Framework and started to program in OOP style. Now my programs are based on my own framework (with elements of cms, but without any design in framework), which is built on the top of the Zend Framework. Now it consists of lots classes. But th...
perfomance of single table vs. joined dual structure
This is not a question about using another tool. It is not a question about using different data structure. It is issue about WHY I see what I see -- please read to the end before answering. Thank you. THE STORY I have one single table which has one condition, the records are not deleted. Instead the record is marked as not active (the...
Problems with large MySQL tables
Hello guys, I'm having some problems with large MySQL tables. The tables are in MyIsam type and some queries can take up to 15 seconds. These tables are mostly read, so this is becoming a problem. My guess is that the software is issuing slow/poorly written queries to the database. Example: implicit joins x explicit joins. If i rewrite...
What's could be the right test case for evaluating assignement operators performance vs concrete operations?
Simply I am trying to figure out what is the fast way to assign a value like somevar+=1; or somevar=somevar+1; time ago in situations with text instead of integers I encountered some performance decrease using text+="sometext" instead of text.append("sometext") or text=text+"sometext", the problem is that I did not find anymore the...
Count SQLClient database queries from ASP.NET app
I need to do some performance testing for an ASP.NET MVC application and specifically want to measure how many databsae queries each HTTP request results in. The data access layer is using LINQ-to-SQL. I'd like to be able to automate the tests so am looking for a good way to be able to do a before and after count of the number of SQL qu...
Why is this List<>.IndexOf code so much faster than the List[i] and manual compare?
I'm running AQTime on this piece of code, I found that .IndexOf takes 16% of the time vs close to 80% for the other piece... They appear to use the same IsEqual and other routines. Called 116,000 times inserting 30,000 items. None of the List<> objects gets over 200 elements. (I may be using AQTime incorrectly, I'm looking into this)...
Improving performance of WCF services working with real time data
In my application I need to push notifications of real time events from server to clients. The amount of data to pass is very small, mostly and Id. The number of clients listening simultaneously can be around 100 and I may have to publish one notification every 2 - 3 seconds. Both the server and client are built using .Net and WCF. Giv...
.net performance counter - Process(w3wp)\% Processor Time
During performance testing, I found that the values of "Process(w3wp)\% Processor Time" are greater than 100. Some values are 237.1436486 312.5338052 341.2373994 264.4097661 191.6237736 I thought this value represents the CPU usage by w3wp process. I don't understand why the value is greater than 100%. Any insights appreciated. Thanks...
Should LINQ be avoided because it's slow?
I've had been told that since .net linq is so slow we shouldn't use it and was wondering anyone else has come up with the same conclusion, and example is: Took 1443ms to do 1000000000 compares non-LINQ. Took 4944ms to do 1000000000 compares with LINQ. (243% slower) the non-LINQ code: for (int i = 0; i < 10000; i++) { foreach (MyLi...
Minify & Gzip vs Google CDN
Should I minify/gzip my Jquery with my other scripts on my page, or use Google CDN for Jquery & JQuery UI and gzip my own stuff. From what I can see its more likely to be faster to deliver from Google and there is a better chance the files will be cached already on the users machine, however its a couple of extra http request and atleas...
YSlow & Google Page Speed's advice on .htaccess conflict
Thanks in advance for your help. I've been experimenting with YSlow and Google page speed, both provide very helpful advice and neither seems to have an advantage over the other but when it comes to Entity tags they seem to disagree or conflict in some way. The following code satisfies YSlows 'Configure entity tags (ETags)' pointer He...