For a complex polygon (ie: self intersecting) the choice between the Winding or the Even-Odd filling rules makes a difference in the way the polygon is filled. But for non intersecting polygons is there any performance difference between the Winding or the Even Odd filling rules. I understand it would be implentation specific but which ...
Hi, I use an HttpHandler to dynamically serve images in a ASP.Net web application. I am having a performance issue (Firfox/Firebug/YSlow reports there are too many HttpRequests) I have between 50-100 images per page in some instances.. 3 treeviews (business units/categories/objects) with each node having its own image ;) Each item's i...
Is there any performance issue in using SELECT * rather than SELECT FiledName, FiledName2 ... ? ...
This table gets hit with this query the most, so I want add a index to speed things up, this table will have 5 million rows it in. My query looks like this: SELECT someID FROM someTable WHERE myVarChar = @myVarChar AND MyBit = 0 AND MyBit2 = 1 AND MyBit3 = 0 myVarChar is unique also. What would the best index be for this t...
For a pet project, I have been looking for a web chat script capable of running potentially tens of thousands of users simultaneously. I don't want to use any kind of applet or browser extension, so on the client side, it should be simple Ajax. On the server side I'm pretty much open to anything. I'm not looking for bells and whistles, ...
In the final stage of development I started looking at code to try to find some bad practices. I discovered that while accessing a page, I'm querying the DB n times (n is the number of rows of an HTML table) just to get the translation (different languages) for a given record... I immediately thought that was bad and I tried a small opti...
Let's say you have a table containing articles and you want want to display a list of them, excluding the actual article text. When you get a list of the article objects using LINQ or the Entity Framework, is there a LOT of overhead associated with getting that text column too? I assume that when you start enumerating the list, the art...
The MSDN site states: A buffer is a block of bytes in memory used to cache data, thereby reducing the number of calls to the operating system. Buffers improve read and write performance. A buffer can be used for either reading or writing, but never both simultaneously. The Read and Write methods of BufferedStream auto...
So we've decided on an EMC NX4 for our storage setup. Database workload Write: ~220 IOPS Read: ~6 IOPS Web workload Write: ~10 IOPS Read: ~55 IOPS I had planned to go for 5 x 15k SAS disks in RAID 10 + hot spare for our databases, and then a 7 x 7,2k SATA RAID 6 + hot spare for our web data. However, EMC conveniently forgot to mentio...
Is it better to describe improvements using percentages or just the differences in the numbers? For example if you improved the performance of a critical ETL SQL Query from 4000 msecs to 312 msecs how would you present it as an 'Accomplishment' on a performance review? ...
My agile team will be adding new features to a existing realty website. As we add the features we want to have a better handle on the site's overall performance as well as the performance of particular pages. I would like to automate the gathering of performance metrics on a request/response basis for each page (e.g. what sub requests...
I created a table in my SQL Server 2005 database and populated it with summary and calculated values. The purpose is to avoid extensive joins and groupings on every call to the database. I would like this table to refresh every hour, but I am not sure the best way to do this while the website is under load. If I delete every record an...
I have a string buffer of about 2000 characters and need to check the buffer if it contains a specific string. Will do the check in a ASP.NET 2.0 webapp for every webrequest. Does anyone know if the String.Contains method performs better than String.IndexOf method? // 2000 characters in s1, search token in s2 string s1 = "Many ...
how to create a performance management system that adjust available services based on current load? any idea lets say I have too many people accessing one page of my website ? how can I build a system which can disable some services for a while (automatically) to save the server from being dawn. because some services parts of the webs...
I recently upgraded one of my applications to Rails 2.2.2. Having done that, I've encountered a strange performance bug that has caused renders that used to complete in a fraction of a second to take up to 10 seconds. I've profiled the issue, and here are the results I've come up with. It looks like the issue is in the real_connect me...
Duplicate: RAMDrive for compiling - is there such a thing? I have an idea how to speed up my IDE. I want to create a RAM disk and move my solution onto this virtual disk. I think that this can speed up the IDE because RAM is much faster than a HDD. Has anyone done this before? PS: I think, when I have some documents in my progra...
Do you think C# TCP/UDP socket use in the managed application can handle (roughly) same amount of data as native C++ version? If not, what is data amount we shall consider native or c# is better to use and what is the biggest obstacle in the implementation on managed side? ...
Is it always good to use stored procedures , is it good for database performance and what kind of queries that you better use stored procedures? Exact Duplicate: When should you use stored procedures? ...
Purely as an experiment, I'm writing sort functions in MATLAB then running these through the MATLAB profiler. The aspect I find most perplexing is to do with swapping elements. I've found that the "official" way of swapping two elements in a matrix self.Data([i1, i2]) = self.Data([i2, i1]) runs much slower than doing it in four lines...
I am working on a web API for the insurance industry and trying to work out a suitable data structure for the quoting of insurance. The database already contains a "ratings" table which is basically: sysID (PK, INT IDENTITY) goods_type (VARCHAR(16)) suminsured_min (DECIMAL(9,2)) suminsured_max (DECIMAL(9,2)) percent_premium (DECIMAL(9,...