.NET provides four very similar versions of String.Format(...) (excluding the one that takes an IFormatProvider argument): Format(String, Object) Replaces one or more format items in a specified string with the string representation of a specified object. Format(String, Object, Object) Replaces the format item in a specified string with...
Every time I find out that the performance of data retrieval from my database is slow. I try to figure out which part of my SQL query has the problem and I try to optimize it and also add some indexes to the table. But this does not always solve the problem. My question is : Are there any other tricks to make SQL server performance be...
I have a bit array that can be very dense in some parts and very sparse in others. The array can get as large as 2**32 bits. I am turning it into a bunch of tuples containing offset and length to make it more efficient to deal with in memory. However, this sometimes is less efficient with things like 10101010100011. Any ideas on a good w...
Assuming the following: /* drop index ix_vouchers_nacsz on dbo.vouchers; drop index ix_vouchers_nacsz2 on dbo.vouchers; create index ix_vouchers_nacsz on dbo.Vouchers( FirstName, LastName, Address, Address2, City, State, Zip, Email ); create index ix_vouchers_nacsz2 on dbo.Vouchers( Email, FirstName, LastName, Address, Address2,...
I'm writing a language interpreter in C, and my string type contains a length attribute, like so: struct String { char* characters; size_t length; }; Because of this, I have to spend a lot of time in my interpreter handling this kind of string manually since C doesn't include built-in support for it. I've considered switching...
I am currently implementing a YUI datatable as a reusable viewer to show sales reports (and other such things) for internal use. The problem is, many of these reports are up to, and even more than 1000 rows long, and client-side performance becomes an issue on even newer, faster machines. For a variety of reasons, server-side pagination...
All of my web pages use a JavaScript library, to improve the performance of my web page, I'd remove all the unnecessary functions/objects from the library for each page according to what's needed for those individual pages. I'm looking for a tool that can do the intelligent stripping automatically. Or in the opposite direction. it will...
I have some performance issues in my JavaScript, and I'm not having much success instrumenting it. One of the things I've tried is using firebug's profile tool. It reports that the top single call was to dojo's log(). Unhelpfully, it reports a line number from the compressed script, so I can't tell what's causing the problem. But it ...
I am designing a system for a customer. We are thinking about using Wordpress as a main platform (instead of writing our custom software), and customize it using addons or hiring developers to write some custom modules. We need to have an ability to have some static pages, few php pages, and lot of user generated content. What limits do...
I am building an application in Winforms. This will talk to DB(oracle) and load huge amount of data (only for viewing). Apart from caching and paging, is there any other point to consider? Performance is an issue, but so is the consideration of limited memory on user machine. Thanks. EDIT - Additional info: I also have an option to bui...
Hy guys. I'm currently working on a project which uses a lot of data stored in session variables. My question is how reliable is this method and if affects the server performance and memory usage. Basicaly, what you would choose between session variables and cookies. ...
I need some help deciding what is better performance wise. I'm working with bigints (more then 5 million digits) and most of the computation (if not all) is in the part of doubling the current bigint. So i wanted to know is it better to multiply every cell (part of the bigint) by 2 then mod it and you know the rest. Or is it better just...
I'm looking at using unity to resolve some interfaces but am not sure about it's performance in terms of scalability. I've registered my dependency types in the web.config and then have this code for a MVP type approach which takes the current web page as the view (IView) in the constructor of the presenter. The code below is taken from ...
I need to store data in a SQL Server 2008 database from various data sources with different data types. Data types allowed are: Bit, Numeric (1, 2 or 4 bytes), Real and String. There is going to be a value, a timestamp, a FK to the item of which the value belongs and some other information for the data stored. The most important points...
Is there any small tool that gives me access to the data gathered by the Intel CPU Counters (like L1/L2 cache misses, branch prediction failures ... you know there are hunderts of them on modern Core2 CPU's). It must work on Windows (while being able to use it with Solaris, FreeBSD, Linux, MacOSX would of course be nice). ...
We have a project for a client that is written in VB.NET. In one of the projects, we have about 100 modules, which are all VERY simple. They're extension methods that convert between object types. Here is a small snippet: Public Module ScheduleExtensions <System.Runtime.CompilerServices.Extension()> _ Public Function ToServicesData(ByV...
I have a "processing..." div overlay that I show with $('').show() prior to making ajax calls and hide on completion. The problem I'm running into is that if I want to show the div and then make several ajax calls prior to hiding the div again it seems to queue the events in Internet Explorer (7) and Chrome (2.0.172.39), but I get the e...
What is the most common performance bottleneck that is not caused by the database structure? ...
Consider the following code: if (IsDebuggingEnabled) { instance.Log(GetDetailedDebugInfo()); } GetDetailedDebugInfo() may be an expensive method, so we only want to call it if we're running in debug mode. Now, the cleaner alternative is to code something like this: instance.Log(() => GetDetailedDebugInfo()); Where .Log() is d...
I recently compared Windows Vista internal Webdav client (mini-redirector) to WebDrive, because Vista seemed to be very slow. I found that Windows Vista uses only 1 HTTP connection and needs 9 requests on average to upload one file, while WebDrive uses 2 HTTP connections for uploading by default (can be configured to use more), and need...