The following is a simplified version of what I'm trying to do, because I'm sure you don't want to wade through an entire set of structs and function prototypes for a particle system. float const materials[24][4][4] = {{{...}}}; typedef struct EmitterStruct { float *material[4][4]; } Emitter; typedef struct ParticleStruct { float mater...
Hi, ok i've got an old classic asp/sql server app which is constantly throwing 500 errors/timeouts even though the load is not massive. Somoe of the DB queries are pretty intensive but nothing that should be causing it to fall over. Are there any good pieces of software I can install on my server which will show up precisely where the ...
We have lots of logging calls in our app. Our logger takes a System.Type parameter so it can show which component created the call. Sometimes, when we can be bothered, we do something like: class Foo { private static readonly Type myType = typeof(Foo); void SomeMethod() { Logger.Log(myType, "SomeMethod started..."); } }...
When designing a ASP.net WebForm application what are some important steps to take (or hacks if you like to use the term) to ensure the best possible performance (in terms of speed, stability, and scalability)? ...
SELECT pe.prodtree_element_id prodID, pe.prodtree_element_name_s, li.line_name, av2.value FROM prodtree_element pe LEFT JOIN prodtree_link pl ON pe.prodtree_element_id = pl.to_prodtree_node_id LEFT JOIN line li ON pe.line_code = li.line_code INNER JOIN attribute_values av ON av.attribute_definition_id = #st...
What is the most efficient algorithm for grouping identical items together in an array, given the following: Almost all items are duplicated several times. The items are not necessarily integers or anything else that's similarly simple. The range of the keys is not even well-defined, let alone small. In fact, the keys can be arbitrar...
I am trying to process files one at a time that are stored over a network. Reading the files is fast due to buffering is not the issue. The problem I have is just listing the directories in a folder. I have at least 10k files per folder over many folders. Performance is super slow since File.list() returns an array instead of an iter...
I'm porting a process which creates a MASSIVE CROSS JOIN of two tables. The resulting table contains 15m records (looks like the process makes a 30m cross join with a 2600 row table and a 12000 row table and then does some grouping which must split it in half). The rows are relatively narrow - just 6 columns. It's been running for 5 h...
I was wondering what I could do to improve the performance of Excel automation, as it can be quite slow if you have a lot going on in the worksheet... Here's a few I found myself: ExcelApp.ScreenUpdating = false -- turn off the redrawing of the screen ExcelApp.Calculation = Excel.XlCalculation.xlCalculationManual -- turning off the ca...
I have a function that looks something like this: //iteration over scales foreach ($surveyScales as $scale) { $surveyItems = $scale->findDependentRowset('SurveyItems'); //nested iteration over items in scale foreach ($surveyItems as $item) { //retrieve a single value from a result table and do some stuff ...
Earlier I asked a question about why I see so many examples use the 'var' keyword and got the answer that while it's only necessary for anonymous types, that it is used nonetheless to make writing code 'quicker'/easier and 'just because'. Following this link I saw that var gets compiled down to the correct type in the IL (you'll see it ...
I am working on a proposal for my company into purchasing some load testing software. I have to give 2 choices. One of my choices I am proposing is HP(Mecurary) Loadrunner. Is there another program out there that is comparible with Loadrunner? We are looking at using the software to test the performance of the following. C# .NET Templa...
In my index.php file I always load some classes used later in code. From profiler it states it sometimes can take about 20% of entire code. Is there any impovement that can make this process faster? I would try to make this list of classes shorter, but app is very big and checking all dependencies will be costly. ...
What is the most efficient way to remove duplicate items from an array under the constraint that axillary memory usage must be to a minimum, preferably small enough to not even require any heap allocations? Sorting seems like the obvious choice, but this is clearly not asymptotically efficient. Is there a better algorithm that can be d...
I'm using Crystal Reports 11 (and VB6) to open a report file, load the data from an Access database and either print the report to a printer or export the report to another .rpt file (for later printing without the database) Even for small amounts of data the process is somewhat slow. Profiling showed about 1.5 seconds for three records...
I am familiar with standard practices to assess performance query or stored procedure using SQL server 2000/2005/2008. How is the best way to assess MDX performance? I assume its possible to write structurely correct but poor performance MDX queries as easily as you can with standard T-SQL? Any suggestions? FYI: I may be tasked with o...
I am planning a fresh installation of SQL Server 2005 on a new machine, which I have to order. I know that tempdb tuning is very important to the overall performance of the SQL Server instance. I've read that it's best practice to create as many tempdb files as you have CPU's (or cores?). Is that correct? Are there any other recommendat...
I've just upgraded a native C++ project from VS2005-SP1 to VS2008-SP1 The first thing I tested was a very basic functionality test of the application and the first thing I noticed is that the main number-crunching algorithm performs three times slower in the VS2008 binary. I tested again the VS2005 binary to make sure there isn't any oth...
I'm implementing a program which utilizes Groovy as scripting engine offering users the possibility i.e. to automate tasks. Hence scripts have to be loaded on demand, which I achieve with the following code: // short version, try/catch and error handling skipped String[] roots = new String[] { "data" }; Binding binding = new Binding(); ...
Which is the best, user-friendliest performance tool for MySQL? I'd like help with pinpointing the bottle neck of my setup. Is the problem in the SQL statements, the settings variables, or something else? ...