computing performance
I need to find out the time a function takes for computing the performance of the application / function. is their any open source Java APIs for doing the same ? ...
performance
SQL Server 2005 Performance: Distinct or full table in WHERE IN statement
Hello, We have two Tables: Document: id, title, document_type_id, showon_id DocumentType: id, name Relationship: DocumentType hasMany Documents. (Document.document_type_id = DocumentType.id) We wish to retrieve a list of all document types for one given ShowOn_Id. We see two possiblities: SELECT DocumentType.* FROM DocumentType W...
Should one use < or <= in a for loop
If you had to iterate through a loop 7 times, would you use: for (int i = 0; i < 7; i++) or: for (int i = 0; i <= 6; i++) There are two considerations: performance readability For performance I'm assuming Java or C#. Does it matter if "less than" or "less than or equal to" is used? If you have insight for a different languag...
Discover what process/query is using the oracle SGA.
I have a query to monitor SGA (non-)utilisation: select sum(bytes)/1024/1024 " SGA Free " from v$sgastat where name='free memory'; That's great, but I need more detail about what exactly is using the space. Essentially, I'm looking for clues to tell me more precisely what might be wrong with this (rather large application). select * f...
Speeding Up C#
This is really two questions, but they are so similar, and to keep it simple, I figured I'd just roll them together: Firstly: Given an established C# project, what are some decent ways to speed it up beyond just plain in-code optimization? Secondly: When writing a program from scratch in C#, what are some good ways to greatly improve ...
Should a developer aim for readability or performance first?
Oftentimes a developer will be faced with a choice between two possible ways to solve a problem -- one that is idiomatic and readable, and another that is less intuitive, but may perform better. For example, in C-based languages, there are two ways to multiply a number by 2: int SimpleMultiplyBy2(int x) { return x * 2; } and in...
.NET SqlConnection NIC usage
Having a computer with multiple NICs, I need to specify somehow the one to use for the connection to SQL Server. ...
SharePoint Lists vs Database Tables performance...
Hi, We are looking to store transactional data in SharePoint lists. The lists will easily grow to 100,000+ items. How would the query performance be compared with queries on a database table with these columns? Queries: Select by Id Select Where ColumnValue = X Group By OrderId Group By Date The SP List will be 6 columns wide: Id, D...
How to keep automated tests fast?
Automated tests MUST be fast to reflect real time project state. The idea is that: after any commit to repository automated build is performed (as fast as it can be done). if build succeeded automated tests are started. MUST be fast. This is the best way i know to find out if your changes break anything. At first it seemed that maki...
Is there some industry standard for unacceptable webapp response time?
There's a cots(commercial off-the-shelf) application that I work on customizing, where a couple of pages take an extremely long time to load for certain distributions of data. (I'm talking approximately 3 minutes for a page to load in this instance... and the time is growing exponentially). Clearly this is unacceptable but are there st...
Techniques to measure application performance
Hi there, I maintain an application which, during the course of two years, has constantly required new hardware to be even usable, due to the amount of new users / new data inserted. However, justifying the investiment is sometimes very hard to do. I started to wonder - how can I establish the maximum number of users a web application...
Optimizations for a Write heavy Oracle application?
What are some useful Oracle optimizations one can use for an Application that mostly writes (updates) to an Oracle database? The general usage pattern here is not web-serving or logging, as is most cases, but instead to persist complex state of a system, so the only times reading is needed is when the system starts up, after that its u...
Left Join outperforming Inner Join?
I've been profiling some queries in an application I'm working on, and I came across a query that was retrieving more rows than necessary, the result set being trimmed down in the application code. Changing a LEFT JOIN to an INNER JOIN trimmed the result set to just what was needed, and presumably would also be more performant (since le...
Visual Studio 6 Processor Pack compatibility
I've seen that a Processor Pack is available for Visual Studio 6, however it appears to only be available for users with SP5 and I am already using SP6: In addition, the Visual C++ Processor Pack (VCPP) was removed from Service Pack 6. If you have the VCPP installed, installing SP6 will remove it from your machine. If you wish to contin...
.NET Fastest way to iterate through rows in a datatable?
Which is generally fastest when reading/comparing row info from a DataTable? 'assume dt as datatable' 'method 1' dim i as int32 for i = 0 to dt.rows.count - 1 .... next 'method 2' dim row as datarow for each row in dt.rows .... next And if there's a difference, in what circumstances does it pay to use one over the other? Th...
Why is require_once so bad to use?
Everything I read about better php coding practices keeps saying don't use require_once because of speed. Why is this? What is the proper/better way to do the same thing as require_once (if it matters, i'm using php5) ...
if(str1==str2) versus if(str1.length()==str2.length() && str1==str2)
I've seen second one in another's code and I suppose this length comparison have been done to increase code productivity. It was used in a parser for a script language with a specific dictionary: words are 4 to 24 letters long with the average of 7-8 lettets, alphabet includes 26 latin letters plus "@","$" and "_". Length comparison we...
In a Web 2.0 site, how long (in sec) should a newly added tag take to show and be indexed for search?
I'm building a web 2.0 site with tagging functionality and wanted to get a sense from anyone with experience how long (in sec) the system can take to a) show a new tag on a given record and b) index the tag for search. For example, does a newly added tag have to be available for search in 1 second but show on the user's screen in .1 sec...
Web Service versus regular Http Request
Hi, About 5000 computers will be making a call to a central server, and they will be passing in a GUID to the central server. The server will then return True/False back to the client. Is there a big difference in performance between a web service and a regular Http request to a Url on the server? ...
Speed of SELECT vs. SET in T-SQL
I've been led to believe that for single variable assignment in T-SQL, set is the best way to go about things, for two reasons: it's the ANSI standard for variable assignment it's actually faster than doing a SELECT (for a single variable) So... SELECT @thingy = 'turnip shaped' becomes SET @thingy = 'turnip shaped' But how fas...