performance

why reflection is slow?

Is it because we shoud load class (by string for example), create instance, then search for appropriate method, pack parameters, and then just invoke method. So the most time is spent on this operations instead of explicit method invocation on an object, right? ...

How to improve this algorithm which fills up a calendar grid?

I have Grid which will render a calendar, and I'm provided with an ArrayList<CalendarEventEntity> which contains events. Those events have to be highlighted in the grid. As I have to fill the grid by my self I have something like this: for( loop through the days of the month ){ Calendar eventDate = event.getDate(); // look for ...

Web application performance and deployment architecture (java)

I have two questions regarding Java web application deployment and its impact on performance. We have an application deployed on serverA, with JSPs exploded in to one content directory (that means JSPs are not part of the WAR) question 1: What I knew was this was an approach for development rather than any other environments. Does this e...

How to test performance for your database Best practice

Hi, I need to test indexes performances for some table in my database. After I run my query with indexes or without them I always use this code; SELECT * FROM sys.dm_exec_query_optimizer_info; And I receive details about my query. My problem is: using sys.dm_exec_query_optimizer The details for my query are always changing making...

EF Takes Forever to Generate this Query

I have a parent-child table relationship. In a repository, I'm doing this: return (from p in _ctx.Parents .Include( "Children" ) select p).AsQueryable<Parent>(); Then in a filter, I want to filter the parent by a list of child ids: IQueryable<Parent> qry; // from above List<int> ids; // huge list (8500) var filtered = fr...

OpenRowSet, OpenQuery, OpenDataSource - which is better in terms of performance

This can be a debatable answer, but I'm looking for the case where a local Excel file needs to be exported to a local SQL Server 2008' table. Has anyone ever had the chance to check execution time to compare OpenRowSet/OpenQuery/OpenDataSource for a very large file import in SQL Server 2008? I'm able to use any of the 3 options, and th...

Increase Performance of DevEx WPF Grid

I'm using the DevEx DXGrid (WPF) to show about 2,000 rows of data. I'm using a DataRow Template to get Master-Detail behavior (a new detail grid for each row). My application responds extremely slow to almost all use input (to the grid). for example: scrolling expand/collapse group rows resize app window I've contacted DevEx suppo...

How to handle absent elements in jquery

For a medium sized app with a medium amount of javascript (in the way of jQuery), what's the best way to combine the javascript into a single file while also avoiding acting on absent elements? For example, given the html: <html> <head><title>Foobar</title></head> <body> <div id='foo'>Bar</div> </body> </html> And the foll...

Getting around the WPF rendering bottleneck

I love to make efficient apps and often look to concurrency and multithreading to improve application responsiveness and such, but lately my attempts always seem to be blocked by WPF's single-threadedness. No matter how efficient and parallel my code is, WPF seems to continually stall my UI and make my app look incredibly unresponsive--s...

Best practice for storing tags in a database?

I developed a site that uses tags (key words) in order to categorize photographs. Right now, what I have in my mysql database is a table with the following structure: image_id (int) tag (varchar(32)) Every time someone tags an image (if the tag is valid and has enough votes) it's added to the database. I think that this isn't th...

ASP.net compiled dlls

Where are they stored? And is there a way to determine when they get deleted? Is there a way to make it so that they are never deleted, so as to improve performance for example? Another issue - in a busy hosting environment how big could all the dll's get? Let's say if you have 1000 medium websites? ...

rails high memory usage

I am planning on using delayed job to run some background analytics. In my initial test I saw tremendous amount of memory usage, so I basically created a very simple task that runs every 2 minutes just to observe how much memory is is being used. The task is very simple and the analytics_eligbile? method always return false, given where...

Order of condition in WHERE statement could improve performances?

Hi, I have a question regarding performance and database. I use MS SQL 2008. I would like to know, if the order of condition in WHERE statement could increase or decrease performance for a SELECT operation. Example: WHERE cnt.IsPublished = 1 AND cnt.TypeContent = 'AR' AND cnt.ModeContent = 'AP' AND cnt.CategoryId = '7'; dfdfd WHE...

is it faster to check a Date for Null or a bit for = 1/0

I'm just wondering what is it faster in sql can have a column of Date and to check it for null or to have a Date and a bit and to check the bit for 1/0 is the bit going to be faster ? ...

Using .htaccess to serve static files via a subdomain

Right, excuse my stupidity, I've looked through a load of examples on t'interweb but I don't think I've found what I'm looking for. I have a website, photography.example.com is the main site but I also want to have another subdomain to serve static files, for example static.photography.example.com. If I request a file (e.g. http://stat...

using ip to link to files in html

wouldn't using ip instead of host name on a dedicated server make page load faster since you avoid the dns lookup? why isn't this done? like using <script src="xxx.xxx.xxx.xxx/javascript.js> <img src=same thing <link href=same thing? ?? ...

Performance impact for specifying qualitative temporal information in Django signals?

When defining a Signal in Django, should you specify qualitative temporal information such as pre and post in the name of the Signal, or as an argument? If as an argument, what range of values should you use? For instance, say I want to define Signals before and after an operation X, one way is: pre_x_signal = Signal(providing_args = [...

How can I measure the number of times and response time of a method called in a Spring Bean

I would like to measure the number of times a method is called on a service provisioned by Spring. In EJB land this information is usually provided by the container. Now since spring is conceived when "Anything you can do, I can do better" was playing on the radio, I expect there to be a nice and elegant component hidden somewhere whi...

is using views faster or slower than just writing the whole sql from scratch

I have 3 tables (A,B,C) and I need quite often to query the result of A inner join B union A inner join C I'm just thinking which way is going to be faster: to write in each query the whole thing from scratch to create a view and use it in queries ...

Visual Studio 2010 C++ linker performance for large projects

Hello, At my company we're still using Visual Studio 2005, but are peeking at Visual Studio 2010 in the hope that it will speed up some parts of our development cycle. At the moment we're most interested in the performance of the C++ linker of Visual Studio 2010. When building our application, we're looking at link times between 40 seco...