performance

Do .pdbs slow down a release application?

If a .pdb (program debug) file is included with a .dll then line numbers appear in the stack trace of any exception thrown. Does this affect the performance of the application? This question is not about release vs. debug, i.e. optimisations. It is about the performance implications of having .pdb files. Are the .pdb files read every ...

Gridview Pagination good or bad-Performance

Dear All, Is Gridview pagination bad? Reason: 1.If javascript is disabled, it will not work. 2.Search engine will not be able to index(I don't know what exactly the reason behind this). Can somebody provide some information? EDIT: Now I am coding it as : protected void GridView1_PageIndexChanging(object sender, GridViewPageEven...

C#, insert multiple records at once to a database

Hi, I'm writing a converter for my database from MSSQL Express Edition to Oracle. The amount of rows in the table is around 5 millions. On MSSQL side I use LINQ to SQL to select data. I'd use the same approach for Oracle, but unfortunately there's no LINQ to Oracle in .NET. I know there is open source LINQ to Oracle implementation, but I...

Is this use of attributes in .Net (C#) expensive?

Hi. I would like to know whether the usage of Attributes in .Net, specifically C#, is expensive, and why or why not? I am asking about C# specifically, unless there is no difference between the different .Net languages (because the base class libraries are the same?). All the newer .Net technologies make extensive use of attributes, ...

StreamWriter .NET - how to get the best performance? C# .Net

What is the recommended approach to get the best performance when we need to create text files bigger than 10MB. There are multiple sections in the code that need to write stuff to a single file. This means a lot of text lines. Option #1: (This logic will be called at several times) Create a StreamWriter instance Write some lines (a...

What features should a C#/.NET profiler have?

This could be a borderline advertisement, not to mention subjective, but the question is an honest one. For the last two months, I've been developing a new open source profiler for .NET called SlimTune Profiler (http://code.google.com/p/slimtune/). It's a relatively new effort, but when I looked at the range of profilers available I was...

Is there a Microsoft SQL Profiler equivalent for Oracle

Hi, 99% of my time is in SQL Server land and so I'm not at all familiar with Oracle or its products...Is there a similar application to Microsoft SQL Profiler for use against Oracle databases? I'm helping debug/tune an ASP.Net application that connects to Oracle using ODAC etc thanks heaps! ...

Problems making an UIImageView opaque on the iPhone

Doing as little alpha blending as possible is an important performance consideration for table view cells on the iPhone. I have table cells that are largely comprised of one big image view. I have set the UIImageView to be opaque, in both Interface Builder and programmatically, but the CoreAnimation instrument still shows that it is bein...

Are there conclusive studies/experiments on C compilation using a C++ compiler?

I've seen a lot of arguments over the general performance of C code compiled with a C++ compiler -- I'm curious as to whether there are any solid experimental studies buried beneath all the anecdotal flame wars you find in web searches. I'm particularly interested in the GCC suite, but any data points would be interesting. (Comparing the...

How many connections/how much bandwidth can Apache handle?

This is a request for pointers to good documentation/good articles. I'm looking for information on how many connections an Apache server can reasonably handle, and potentially how to load balance between multiple servers. I've done Google searches but it's harder for beginners to judge what are good docs. ...

Linq To SQL: Why is disposing and recreating a DataContext way faster than refreshing it?

Hey, I noticed that disposing and re-creating a DataContext is way faster than refreshing it with RefreshMode.OverwriteCurrentValues, which should effectively be the same. While this causes my application to spike at 100% CPU for several seconds dbc.Refresh(RefreshMode.OverwriteCurrentValues, dbc.Property); the following code doesn...

Fastest way to move a part of an array to the right

I need to "insert" an element at the given index in a small array. That is, to move all elements with greater indices 1 place to the right. What is the fastest way to do that in .NET? NOTE: I added my own answer, but I am still looking for an explanation and faster alternatives. EDIT: I do need an array, not a List<T> and not a linked...

Fast stable sort for small arrays (under 32 or 64 elements)

The common wisdom says that for small enough arrays insertion sort is the best. E.g., Timsort uses (binary) insertion sort for arrays up to 64 elements; from Wikipedia: Some divide-and-conquer algorithms such as quicksort and mergesort sort by recursively dividing the list into smaller sublists which are then sorted. A useful optimi...

Why is PageSettings.PrintableArea so slow?

I'm writing an application that does a lot of batch printing, but each print is taking several seconds to complete. I've tracked it down to the getter of property PageSettings.PrintableArea in System.Drawing.Printing - each call to that takes over one seconds to finish! Can anyone shed any light onto why this is, and also how it can be ...

Overhead of pthread mutexes?

I'm trying to make a C++ API (for Linux and Solaris) thread-safe, so that its functions can be called from different threads without breaking internal data structures. In my current approach I'm using pthread mutexes to protect all accesses to member variables. This means that a simple getter function now locks and unlocks a mutex, and I...

String matching in Oracle 10g where either side can have wildcards

Test case schema and data follow as: create table tmp ( vals varchar(8), mask varchar(8) ); insert into tmp values ('12345678',' '); insert into tmp values ('12_45678',' _ '); insert into tmp values ('12345678',' _ '); insert into tmp values ('92345678',' '); insert into tmp values ('92345678',' _ ')...

Why is copying references to strings much slower than copying ints (but vice versa for Array.Copy())?

Let's say I want to move a part of an array right by 1. I can either use Array.Copy or just make a loop copying elements one by one: private static void BuiltInCopy<T>(T[] arg, int start) { int length = arg.Length - start - 1; Array.Copy(arg, start, arg, start + 1, length); } private static void ElementByElement<T>(T[] arg, int...

Cocoa/Objective-C: how much optimization should I do myself?

I recently found myself writing a piece of code that executed a Core Data fetch, then allocated two mutable arrays with the initial capacity being equal to the number of results returned from the fetch: // Have some existing context, request, and error objects NSArray *results = [context executeFetchRequest:request error: NSMutableArra...

Something like Psyco library (Python) for Ruby, exists?

I need more performance in a part of a program, coded in Ruby. In Python i could use Psyco library (that compiles the code, or a part before the execution) to improve the perfromance, but i dont know if exists something like that in Ruby. Thanks! ...

Which server parameters to tweak in Solr if I expect heavy writes and light reads?

I am facing scalability issues designing a new Solr cluster and I need to master to be able to handle a relatively high rate of updates with almost no reads - they can be done via slaves. My existing Solr instance is occupying a huge amount of RAM, in fact it started swapping at only 4.5mil docs. I am interested in making the footprint ...