performance

LINQ to SQL Pagination and COUNT(*)

I'm using the PagedList class in my web application that many of you might be familiar with if you have been doing anything with ASP.NET MVC and LINQ to SQL. It has been blogged about by Rob Conery, and a similar incarnation was included in things like Nerd Dinner, etc. It works great, but my DBA has raised concerns about potential fut...

Acessing netstat-like data with .NET

Hi there, I'd like to know if there is any way to access info like number of discarded packets from within .NET framework. I am aware of Win32_PerRawData and Ip Helper API. Thanks in advance ...

What Performs Worse: Reflection or Boxing?

I'm working on creating my own DI framework that creates delegate factories as a learning exercise. My way of building typed delegates is to use expressions to create a function that calls a static method with reference to my container and any constructor params. This thrown up an interesting question with regards to value types. Whic...

Should I store reference data in my application memory, or in the database?

I am faced with the choice where to store some reference data (essentially drop down values) for my application. This data will not change (or if it does, I am fine with needing to restart the application), and will be frequently accessed as part of an AJAX autocomplete widget (so there may be several queries against this data by one us...

Recommend a book on load-testing an ASP.NET application

I need a book to recommend strategies for load-testing an ASP.NET application with SQL Server backend. Some info that may be useful: how to write a load test plan what perfmon counters to use and typical threshold values finding bottlenecks various load testing tools ...

Cross Platform System Usage Metrics

Is there a cross platform C API that can be used to get system usage metrics? ...

JavaScript: Appending children to element

Which technique below is better from a user experience? In both examples, assume that thumbContainer is set to the return value of document.getElementById('thumbContainer'), and new Thumbnail(thumb).toXMLString() returns a string with XHTML markup in it. A) Simply += with thumbContainer.innerHTML: for (thumb in thumbnails) { thum...

Storing microseconds in MySQL: which workaround?

Hi, we're writing a scientific tool with MySQL support. The problem is, we need microsecond precision for our datetime fields, which MySQL doesn't currently support. I see at least two workarounds here: Using a decimal() column type, with integer part corresponding to seconds since some point in time (I doubt that UNIX epoch will do, ...

save db access file in to pendrive

Hi I have a very small application. This save data in mdb file (this mdb file only have 2 tables). MDB file is stored in my PC. From application I can set the path to my .mdb file. I have installed my app in 2 PC (office and home) and now I want to save mdb file in 1 pendrive. This way when I go home only I will have to plug the pendr...

Performance bottleneck - Linq to SQL or the database - how do I tell?

Hi, I am currently trying to ring more performance out of my reporting website which uses linq to sql and an sql server express 2008 database. I am finding that as I now approach a million rows in on of my more 'ugly' tables that performance is becoming a real issue, with one report in particular taking 3 minutes to generate. Essential...

XML and SQLite memory utilization and performance on the iPhone

How do the memory utilization and performance for XML or SQLite compare on the iPhone? The initial data set for our application is 500 records with no more than 750 characters each. How well would XML compare with SQLite for accessing say record 397 without going through the first 396? I know SQLite3 would have a better methods for tha...

Calculating how many Working Days between 2 Dates - T-SQL?

I realise different solutions will have different variations of what "Working Days" means but in my case I mean Monday to Friday inclusive. Basically I have Created a function to do the calculation for me and my current solution works. My concern (and reason for asking this question) is that I am worried that this is a bad way of achiev...

Will Perl be the bottleneck in this kind of image processing?

The processing I have in mind is this: there are thousands of png files each of them should be loaded, and its pixels accessed each pixel's channels will be processed in some way, and then written to a binary file I was thinking of using some sort of module, like ImageMagick wrappers, or some other wrapper for a C image processing ba...

Project Euler Problem# 276 - Primitive Triangles

Hi, I tried to solve problem# 276 from Project Euler, but without success so far. Consider the triangles with integer sides a, b and c with a ≤ b ≤ c. An integer sided triangle (a,b,c) is called primitive if gcd(a,b,c)=1. How many primitive integer sided triangles exist with a perimeter not exceeding 10 000 000? The bo...

WPF UI Suggestions?

I have a UI with some controls, then in the middle I have 6 overlapping grids. I am using these grids as 'pages' and as the user navigates through the 'pages' I cycle through using Visible.Hidden and Visible.Visible to show the correct 'page'. I noticed while developing as I was adding more grids the application started to slow down (a...

Efficient way of finding distance between two 3D points

hi, I am writing a code in C++ and want to compute distance between two points. Question 1: I have two points P(x1, y1, z1) and Q(x2, y2, z2) , where x, y and z are floats/doubles. I want to find the distance between these two points. One way to do it is : square_root(x_diff*x_diff + y_diff*y_diff + z_diff*z_diff) But this is ...

SQL Stored Procedure Problem due to the Lack of SP Performance

The main problem is that in my sp there are different objects and logic that may cause lack of performance. The things that I see on my SP and the tables that are in use in the SP 1- Temp tables such as shown below; (2 Temp Tables) CREATE TABLE #TEMP_TABLE( AB INT NOT NULL, AC INT NOT NULL, AD INT NOT NULL, AF INT NULL, AG IN...

Materialized view or CDC?

I have a view on two tables (stored using SQL 2008) with millions of records. CREATE VIEW VwSalesAge AS SELECT Transactions.ID ,Transactions.Amount ,Customer.ID ,Customer.Name ,Customer.Age FROM Transactions INNER JOIN Customer ON Transactions.CustomerID=Custo...

How to organize JS loading?

I have a serious project with big JS file with many functions, and now I have some questions about it. Of course, I will stick together all my js files and gzip it, but I have a question about functions initialisations. Now I have many, many simple functions, without any classes. I heard that it is better to separate my code into many ...

Webservice wcf performance counters for queue

Hi, Am trying to performance test a wcf webservice which should get a lot of traffic. Which performance counters are sensible to use and for which purpose..Naturally I am looking at CPU and RAM, but I would like to know when IIS is queing and when its having trouble... Any advice on sensible performance counters gratefully received... ...