performance

.NET Cross-Assembly Performance Hit

I am reading Bill Wagner's book Effective C#. In Item 32 he is advocating for developers to create smaller, more cohesive assemblies that can be reused more readily. However, in that same item he says: ... Extra Security checks also are done across assembly boundaries. All code from the same assembly same has the same level ...

Which method is faster in SQL Server? Returning XML data or raw data that is consumed via a DataTable??

Hi there, The server scalability is a major concern for us. I am trying to do as much of the processing on the client as possible and since SQL server 2008 does not have native support for JSON but it does for XML... I thought if I return my data (using FOR XML EXPLICIT), and then in C# (BRL Layer), I can just use one SqlDataReader ca...

How can I code Java to allow SSE use and bounds-check elimination (or other advanced optimizations)?

The Situation: I'm optimizing a pure-java implementation of the LZF compression algorithm, which involves a lot of byte[] access and basic int mathematics for hashing and comparison. Performance really matters, because the goal of the compression is to reduce I/O requirements. I am not posting code because it isn't cleaned up yet, and...

Python script performance as a background process

Im in the process of writing a python script to act as a "glue" between an application and some external devices. The script itself is quite straight forward and has three distinct processes: Request data (from a socket connection, via UDP) Receive response (from a socket connection, via UDP) Process response and make data available to...

Problem with ORs in JOIN statement

I have a problem with the SQL statement detailed below. The query returns the results I need, but takes an insane amount of time to execute. I now have so many records in the db that the page generally won't load. SELECT dscan.guid, dscan.drive, dscan.folder, dscan.filename, source.guid FROM source RIGHT JOIN dscan ON ( (source.gui...

Significant Performance Decrease when moving from Windows Server 2003 to 2008 (IIS 6 to IIS 7)

Hello Folks: Our ASP.Net 2.0 web app was running happily along on Windows Server 2003. We were starting to see some of the limits of the environment approaching, such as memory and CPU usage spikes, and as we're getting ready to scale we decided it was time for a larger server with higher availability. We decided to move to Windows Se...

About general logging, caching and performance in new framework

Hi there. I am creating a new PHP framework depending on Zend Framework. It will be a general purpose MVC framework for web development. I am worried about 2 aspects: Logging: Should I use logging? Is there any substantial performance problems when using logging? Caching database queries: I am caching some queries from database. I am c...

JQuery performance with many plugins?

I've been using JQuery for a while, but primarily without plugins - I'm now looking to do a project which could take advantage of a bunch of plugins - Are there any performance penalty to using a lot of plugins in a project - Lets say something in the order of 10-20 plugins? And how will the performance be affected if JQuery and it's pl...

SQL Server Datetime vs Int key performance

For you database design/performance gurus out there. If you have a database that is intended to track financial data for fiscal year periods, is it better/more performance/more clear to do daterange type searches like PaymentDate Between X and Y or is it better to keep a int-key based table with fiscal year periods defined in it and tag...

Displaying huge arraylist in jsp

Hi All, I have 15000 records in an arraylist each record size is around 2MB. I have display this list on a jsp page in the most efficient manner. Please suggest the best method to do it. I can not filter data on server side. User needs all records on jsp page at once. Thanks in advance. ...

How to change locking strategy in SQL Server?

I've read articles like these: http://www.codinghorror.com/blog/archives/001166.html http://www.databasejournal.com/features/mssql/article.php/3566746/Controlling-Transactions-and-Locks-Part-5-SQL-2005-Snapshots.htm And from what I understand, SQL Server has a very pessimistic locking strategy. And to improve performance, I should chang...

Will Interning strings help performance in a parser?

If you are parsing, lets just say HTML, once you read the element name, will it be beneficial to intern it? The logic here is that this parser will parse the same strings (element names) over and over again? And several documents will be parsed. Theory: // elemName is checked for null. MarkupNode node = new MarkupNode() { Name = St...

java: how many times is the collection expression evaluated in a "foreach"

if I do this in Java: for(String s : myCollection.expensiveListGeneration()) { doSomething(); } is expensiveListGeneration() invoked just once at the beggining or in every cycle iteration? Is it implementation dependent? ...

How to freeze web browser's repaints while changing visibility of elements?

Hello there, I'm by far no JS developer (in fact, hardly developer at all :) but I wanted to try to write a small Greasemonkey script to hide few elements on a certain webpage. Once I've started dabbing at it, I've decided to use jQuery, just to make it easier. Everything went well, the script is working, but now that it's ready, I've s...

Different ways of initializing a Model for a View in ASP.NET MVC

How much is the actual memory / performance gain in an ASP.NET MVC controller when using these two different ways of declaring the Model for a view? User user = userService.GetByID(id); return View(user); or return View(userService.GetById(id)); I'm supposing that the last one is a bit more performant as we do not initialize an obj...

choppy graphics when drawing xna on a winforms control

I'm drawing an xna project on a winforms Control using the following code: this.GraphicsDevice.Present(MainForm.GamePanelHandle); This winforms control is placed on a Form that is maximized, hiding the taskbar using the following code: this.FormBorderStyle = FormBorderStyle.None; this.WindowState = FormWindowState.Maximized; Unfort...

Save text on XML file or Database.

Hi everybody, I'm working partime for an company and my boss ask me to make an module for prestashop to read/write news ( only Text ) into a XML file. But i think load text form XML will be slowly. Anybody can tell me save text in XML file or Database, which better and why?? Thanks. :) ...

What's the fastest way to return a list of objects in C#?

I'm writing a plug-in for a 3D modeling program. There is a a feature of the API where you can intercept the display pipeline and insert additional geometry that will be displayed with out actually being in the model (you can see it but you can't select/move/delete etc. etc..). Part of this feature of the API is a method that gets calle...

Java - Looking for something faster than PriorityQueue

Hi, i'm using java on a big amount of data. [i try to simplify the problem as much as possible] Actually i have a small class (Element) containing an int KEY and a double WEIGHT (with getters&setters). I read a lot of these objects from a file and i have to get the best (most weight) M objects. Actually i'm using a PriorityQueue wi...

WPF 3-D performance for head-tracking app

I’m working on creating a full-screen 3-D app (based on Johnny Lee's Wii head tracking app) with some augmented reality features, and it seems that WPF is too slow to render even the simple models I’m using at a reasonable frame rate. I think the problem is that I need to change both the view and projection of the camera on just about ev...