I have recently installed a new project into my Eclipse and also needed to install some plug-ins to manage it. I also installed other plug-ins which I do not need to manage the project but thought it will be nice to try out. After this, I noticed that my IDE isn’t as fast to respond as before. I’m not sure if it has something to do with...
If I'm am trying to squeeze every last drop of performance out of a query what affect does having these types of index's being used by my joins. clustered index. non-clustered index. clustered or non-clustered index with extra columns that may not be involved in the join. Will I gain any performance if I go through and create cluster...
In the query below is it better for performance to move the case statement to a UDF? If so why? SELECT id, name, case when v1 = 'Y' then 'something' when v2 = 'K' then 'something else' when v3 is null then 'dont know' else 'default' end from table ...
Hey there! I'm trying now for quite a while to optimize the framerate of my game without really making progress. I'm running on the newest iPhone SDK and have a iPhone 3G 3.1.2 device. I invoke arround 150 drawcalls, rendering about 1900 Triangles in total (all objects are textured using two texturelayers and multitexturing. most textu...
My application is very database intensive so I've tried really hard to make sure the application and the MySQL database are working as efficiently as possible together. Currently I'm tuning the MySQL query cache to get it in line with the characteristics of queries being run on the server. query_cache_size is the maximum amount of data...
My flex application, processes user request and makes an HTTP request to the backend, for data processing, and renders the data on the UI. (typical HTTP request-response based application). I need to do a performance analysis on the whole system, in order to identify and resolve bottlenecks, hence need to measure the time-split of the w...
In my project I have some code which has been deveoped in VBA and it calls functions from different C# DLLs. currently the performance of the code has been degraded and I am planning to check in which function/dll most of the execution time is spent. Kindly let me if any tool is available to check the same. ...
Challenge: Perform a bitwise XOR on two equal sized buffers. The buffers will be required to be the python str type since this is traditionally the type for data buffers in python. Return the resultant value as a str. Do this as fast as possible. The inputs are two 1 megabyte (2**20 byte) strings. The challenge is to substantially bea...
I have been searching around for days to find an answer to this performance based issue. After digging the Internet so far I have learned that there are couple of ways to use the Enums in java, well documented in here. Well, definitely as a starter one would like use Enums in a switch-case statement, which provides clarity and better un...
In the past I've used performance profiling tools such as nprof, Equatec profiler and Yourkit profiler to identify and remove/reduce performance bottlenecks in code mostly running in one thread (serialized execution). Nowadays I write a lot of multi-threaded code which can be slowed down by lock contention; what tools and tricks can be u...
I'm trying to test the utility of a new summary table for my data. So I've created two procedures to fetch the data of a certain interval, each one using a different table source. So on my C# console application I just call one or another. The problem start when I want to repeat this several times to have a good pattern of response time...
We have a process that is getting data in real time and adding records to a database. We're using SQL Server 2008 Integration Services to run our Extract Transform Load (ETL) process. We download about 50 files from an FTP site, process them and then archive the files. The problem is that the processing is taking about 17s per file even...
I know that Grails and Asp.net cannot be directly compared but still, does anyone know if there's something available for ASP.net that even remote resembles the functionality of the UI-Performance Plugin for Grails? ...
G'day, We have built a 64bit build of Apache 2.2.14 and deployed it across various Sun servers running Sol10. Server types used for testing are Sun T2000's (32GB memory), 5120's (8GB) and 5240's (16GB). For each of these we have noticed that there was no appreciable improvement in CPU usage and in fact the server is running slightly ho...
Our Moodle site is starting to see heavy use and as a result, the site is starting to slow down. I know it is specific to this site as others on it have no problems with large workloads. What are some of the configuration options I should check for right off the bat when performance tuning Moodle? ...
What are examples of SQL Server Query features/clauses that should be avoided? Recently I got to know that the NOT IN clause degrades performance badly. Do you have more examples? ...
Is there a measure of time frame as to which the execution plan of inline queries will cached? ...
Our application tends to be running very slow recently. On debugging and tracing found out that the process is showing high cpu cycles and SQL Server shows high I/O activity. Can you please guide as to how it can be optimised? The application is now about an year old and the database file sizes are not very big or anything. The database...
I'm using Hibernate to work on a new project, and as I work I'm realizing that my original vision for the application may not end up being its destiny. Data that I think is not going to be often requested (and thus lazy-loaded) might end up being needed for 85% of requests. Conversely, data that I'm loading under the assumption it will b...
How to find the execution time for various Model API Calls in Django. ...