I've been doing a lot of DB refactoring lately and synonyms have come in incredibly useful. When I originally put in the synonyms I was thinking they would be very temporary while I refactor. Now I am thinking there might be some good reasons to keep some of these synonyms around. Has anyone used them as full blow abstraction layer? Wh...
Hi, In my Rails App I've several models dealing with assets (attachments, pictures, logos etc.). I'm using attachment_fu and so far I have 3 different tables for storing the information in my MySQL DB. I'm wondering if it makes a difference in the performance if I used STI and put all the information in just 1 table, using a type colum...
In my project I have very big XSD file which i use to validate some XML request and response to a 3rd party. For the above scenario I can have 2 approaches 1) Create XML and then validate against give XSD 2) Create classes from XSD with the help of XSD gen tool, add xtra bit of attirbutes and use them for validation. Validation in the...
Duplicate How slow is Reflection (C#) What are some of the performance considerations when using reflection to iterate through properties and using attributes on properties in c#.net? ...
I have several dozen 64-bit Windows 2003 servers in a high performance environment with very bursty system utilization. I am looking for a tool (or tools) to monitor and analyze system performance (eg, CPU utilization, bandwidth, etc). This tool can either query servers from a central location (SNMP) or require installation of a compone...
There is a PHP application right now on a Linux box running under Apache with MySQL. Since we are a windows shop, management wants to get rid of the Linux box and move everything over to windows. Is there a performance difference between the two platforms? Or, is there any significant difference at all, in terms of performance or managem...
Many types in WPF derive from Freezable. It provides immutability to mutable POCO objects and allows for improved performance in certain situations. So my question is, how can I freeze objects in XAML markup? (Note that I have posted a similar but different question too). ...
Many types in WPF derive from Freezable. It provides immutability to mutable POCO objects and, apparently, allows for improved performance in certain situations. Has anyone found that freezing objects within their WPF application has greatly improved performance? If so, then which items gave the biggest performance difference when bei...
We have an application that performs comparisons on data objects to determine if one version of the object is different than another. Our application also does some extensive caching of these objects, and we've run into a bit of a performance issue when it comes to doing these comparisons. Here's the workflow: Data item 1 is the curre...
Suppose for any url if a '//' is added instead on '/' by accident in the request. Can this effect the http request performance? e.g. http://www.microsoft.com/downloads v/s http://www.microsoft.com//downloads This reason I am asking this is; in one of our application the dynamic urls were building wrong on production server for som...
I have a very large dataset, each item in the dataset being roughly 1kB in size. The data needs to be queried rapidly by many applications distributed over a network. The dataset has more than a million items (so 500 million+ 1kB data chunks). What would be the best method to storing this dataset (need to allow adding more items, and r...
I need to store in a constant class 4 letter of a code. I can do: static final String CODE_LETTERS = "TRWAG"; or static final char[] CODE_LETTERS = {'T', 'R', 'W', 'A', 'G'}; After, I can obtain one of that characters in two ways: final char codeLetter = CODE_LETTERS.charAt(index); or final char codeLetter = CODE_LETTERS[index]...
Hello, I have List collection with around 35,000 strings Typical string looks like this: "<i>füüs</i>ampri tähis;lüh ld-st<i>anno</i>, aastal;<i>maj</i> lüh pr-st<i>argent</i>, raha (kursisedelitel)" Basically this string contains bunch of words in Estonian :) I need to allow user to perform RegExp search on 35,000 strings If I pe...
We recently pushed a web application (tomcat 5.5.x web app) into production and it started exhibiting odd behavior today. We don't see this behavior in any development or pre-production environment. Our only view into the production system at runtime is logging. Although they can tell us what happened they can't really help us diagnose ...
I'm generating regular expressions dynamically by running through some xml structure and building up the statement as I shoot through its node types. I'm using this regular expression as part of a Layout type that I defined. I then parse through a text file that has an Id in the beginning of each line. This id points me to a specific lay...
I need to store a multi-dimensional associative array of data in a flat file for caching purposes. I might occasionally come across the need to convert it to JSON for use in my web app but the vast majority of the time I will be using the array directly in PHP. Would it be more efficient to store the array as JSON or as a PHP serialized...
I've been playing with collections and threading and came across the nifty extension methods people have created to ease the use of ReaderWriterLockSlim by allowing the IDisposable pattern. However, I believe I have come to realize that something in the implementation is a performance killer. I realize that extension methods are not sup...
hi, i'm trying to join 8 tables into one in order to create index used by other application, my query is like : (my mysql skill's very amateur) SELECT t1_id, t2_name, t3_name, t4_name, t5_name, t6_name, t7_name, t8_name, t9_name FROM t1 LEFT JOIN t2 ON (t1_id = t2_id) LEFT JOIN t3 ON (t3_id = t1_id) LEFT JOIN t4 ON (t4...
Hi! I've created a WPF control (inheriting from FrameworkElement) that displays a tiled graphic that can be panned. Each tile is 256x256 pixels at 24bpp. I've overridden OnRender. There, I load any new tiles (as BitmapFrame), then draw all visible tiles using drawingContext.DrawImage. Now, whenever there are more than a handful new til...
I have a web application inside where i need to check whether the user has sufficient permissions / roles/rights to access the page. I had set the users rights in a table with USER_ID, ROLE_ID. and when a user is logging in to the application, I will be reading the records for this user and the construct a string and assign to a sessio...