I am facing a problem. I have one query Select * from tabA where (a) in (a,b,c) OR b in (a,b,c) I want to facing performance issue due to this query as I need to remove the or condition , so I tried with the following query: Select * from tabA where (a,b) in (a,b,c) but this query seems not to work, please help. I dont want to...
I'm binding a lot of data to a TreeView control as the data is a natural category hierarchy. The problem is that there is a lot of it. I have managed to remove a lot of the overhead by only binding those nodes which appear in the visible tree, but this still leaves a lot in the ViewState, et al. Does anyone have a method or alternative ...
Possible Duplicate: Whats the main difference between int.Parse() and Convert.ToInt32 Hi guys, I would like to know what are PRO and CONS of using Convert.ToInt32 VS int.Parse. Thanks for you support! Here an example of syntax I am using int myPageSize = Convert.ToInt32(uxPageSizeUsersSelector.SelectedValue); ...
Hello Im having an ongoing issue with my site, it basically times out and dies. I have gotten to the point now where I have had to set the application pool to auto recycle every 5 minutes, but even that has failed as I’ve just got back from work and my email inbox is full of 4000 emails all with the same error. System.Data.SqlClient.Sq...
Quoting from http://sites.google.com/site/gson/gson-design-document: Why are most classes in Gson marked as final? While Gson provides a fairly extensible architecture by providing pluggable serializers and deserializers, Gson classes were not specifically designed to be extensible. Providing non-final classes woul...
I have to do reflection and late binding so i don't know if there is a way to speed things up. Thought I would give it a shot. This snippet takes about 15 seconds to complete which is way too slow, but seeing how I need to read the metadata. private static object InvokeCall(Type HostObjectType, Object HostObject, CallType callType, st...
I have done some really serious refactoring of my text editor. Now there is much less code, and it is much easier to extend the component. I made rather heavy use of OO design, such as abstract classes and interfaces. However, I have noticed a few losses when it comes to performance. The issue is about reading a very large array of recor...
can you please suggest any books/references(other than listed below) for a developer who is gonna develop highly scalable system in java? I know these books cover performance relates topics: effective java,va Concurrency in Practice and java performance tuning books Thanks ...
SELECT * FROM openorders_tracking WHERE id NOT IN (SELECT tracking_id FROM openorders_commission) SELECT * FROM openorders_tracking LEFT JOIN openorders_commission ON openorders_tracking.id=openorders_commission.tracking_id WHERE openorders_commission.id IS NULL I'm wondering both specifically for this query, and in general if...
Hi Everyone, I need to calculate some performance numbers for a few custom session storage providers. I need to know how long it takes to rehydrate session and how long it takes to persist it back to the store. None of the providers provide this level of detail in the debug information. Is there a generic way of tracking session load ...
I've been playing around with the samus mongodb driver, particularly the benchmark tests. From the output, it appears the size of the documents can have a drastic effect upon how long operations on those collections take. Is there some documentation available that recommends what balance to strive for or some more "real" numbers aroun...
Ideally I'm looking for a c# solution, but any help on the algorithm will do. I have a 2-dimension array (x,y). The max columns (max x) varies between 2 and 10 but can be determined before the array is actually populated. Max rows (y) is fixed at 5, but each column can have a varying number of values, something like: 1 2 3 4 5 6 7.....
I'm using dynaTrace to profile my application in Internet Explorer. One of the most expensive calls is the following: $("div.containerClass:has(div.containerHeader)") I scoped the selector as follows, which offered a little improvement: $("div.containerClass:has(div.containerHeader)", "#section-wrapper") How can I improve the perf...
Context: Domain model of Documents having Editions and Tags. What kind of figures are you going to expect when hydrating using nHibernate? My domain model not very complex and when I query all Documents fetching Editions as well as Tags the query returns a little more than 8000 rows from the database - which in turn are hydrated into a...
On our production server we need to split 900k images into different dirs and update 400k rows (MySQL with InnoDB engine). I wrote a python script which goes through next steps: Select small chunk of data from db (10 rows) Make new dirs Copy files to the created dirs and rename it Update db (there are some triggers on update which will...
Hi, The question might sound vague but I'm trying to understand the general concept of the EHCache transaction ability. Assuming I configure EHCache as a memory cache and I also configure it to cache a MyObject. Does EHCache clone the instance of MyObject I'm retrieving if this is done as a part of a transaction? I'm mainly asking bec...
Are there any disadvantages or performance slowdowns related to the use of expressions like from i in Enumerable.Range(1, Math.Min(strTexto.Length, tamMax) + 1) select Tuple.Create(strTexto.Substring(0, i - 1), strTexto.Substring(i - 1)) in C#? Is it preferable to build "hard-coded queries" like foreach (Int32 IntTmp ...
Hello, We just ported our WinForms application to WPF. However, performance decreased dramatically. We have a User Interface which consists of about 200 UserControl. Each UserControl is defined by a DataGrid (= 10 columns and 3-15 rows) as well as a Panel which hosts about 10 Buttons. They are all hosted in a ScrollViewer. (Please do...
IMO, please correct me... the leaf of clustered index contains the real table row, so full clustered index, with intermediate leaves, contain much more data than the full table(?) Why/when/how is ever whole clustered index scan chosen over the full table scan? How is clustered index on CUSTOMER_ID column used in SELECT query which ...
I'm working on a game and having some performance problems drawing one canvas onto another with drawImage. According to Chrome's Profiler, I'm spending 60% of my time in just this one drawImage call and 10% in the clearRect above it... The source canvas is about 3000x3000 for now (which is pretty small, I'd say) and the destination canv...