Hi, I'm developping an XNA game and I usually start my application in windowed mode for debug purposes. For strange reasons, my application is 50% slower in windowed mode than in fullscreen mode. Can someone tell me why and how the windowed mode affects the framerate ? ...
Hello all. I am creating a calendar webapp and I'm kinda stuck between a performance vs storage issue in the creation and subsequent queries of my events table. The concept is "how to make a table with repeating events (daily/weekly)?" Here is my current solution: CREATE TABLE `events` ( `eventid` int(10) NOT NULL AUTO_INCREMENT, ...
One day I suspect I'll have to learn hadoop and transfer all this data to a non-structured database, but I'm surprised to find the performance degrade so significantly in such a short period of time. I have a mysql table with just under 6 million rows. I am doing a very simple query on this table, and believe I have all the correct in...
SELECT * FROM myTable WHERE field1 LIKE 'match0' AND myfunc(t1.hardwareConfig) LIKE 'match1' Here is my question, the matching of field1 is fast and quick, but myfunc takes forever to return and I want to make sure that if field1 doesn't match that it doesn't even attempt to do myfunc. Will SQL just know this or can I make it...
Being stuck in a MS stack architecture/development position for the last year and a half has prevented me from staying on top of the world of open source stack based web servers recent evolution more than I would have liked to. However I am now building an open source stack based application/system architecture and sadly I do not have th...
What do you do to increase startup speed (or to decrease startup time) of your Delphi app? Other than application specific, is there a standard trick that always works? Note: I'm not talking about fast algorithms or the likes. Only the performance increase at startup, in terms of speed. ...
I don't understand the output from the "Leaks" performance tool in XCode. How can I interpret this output? ...
When writing ASP.NET pages, what signs do you look for that your page is making too many roundtrips to a database or server? (This is a general question but I say ASP.NET as the majority of my coding is on the web side of things). ...
Hi In a stored procedure (which has a date parameter named 'paramDate' ) I have a query like this one select id, name from customer where period_aded = to_char(paramDate,'mm/yyyy') will Oracle convert paramDate to string for each row? I was sure that Oracle wouldn't but I was told that Oracle will. In fact I thought that if the param...
Hi all, I was wondering - how do people handle importing large numbers of commonly used modules within django views? And whats the best method to do this efficiently? For instance, I've got some views like, admin_views.py search_views.py . . and from what I've seen, every one of them needs to use HttpResponse or other such commonly ...
Is there any performance difference between myCollection.Where(...).FirstOrDefault() and myCollection.FirstOrDefault(...) Filling in the dots with the predicate you are using. ...
Hi guys I am in the process of creating some fluent interfaces for some simple validation stuff that I am playing around with. One thing that I have noticed is that I have a lot of different objects being created. For instance given the below statements: Check.Assertion.ForValue.That(value, "value").IsNotNull() : void Check.Assertio...
In my current project, the business logic is implemented in stored procedures (a 1000+ of them) and now they want to scale it up as the business is growing. Architects have decided to move the business logic to application layer (.net) to boost performance and scalability. But they are not redesigning/rewriting anything. In short the sam...
We're in the process of creating a new API for our product, which will be exposed via web services. We have an internal debate whether the API should be as easy as possible to use (in the price of making more calls) or make it as efficient as possible (rendering it harder to use). For example, here are two issues that came up: Should w...
I'm storing localized strings in a single datatable using MS Sql (2008 or whatever). Most of the strings are short and can be represented with varchar(200), while about 10% are much longer require something like varchar(5000). My question is, is there a performance advantage when retrieving shorter strings if I break this into two tables...
Regarding setting Django's USE_I18N = False in settings.py the documentation say: A boolean that specifies whether Django's internationalization system should be enabled. This provides an easy way to turn it off, for performance. and: If you don’t use internationalization, you should take the two seconds to set USE_...
I've seen other threads saying java reflection performance is 10-100x slower than when using non-reflection calls. My tests in 1.6 have shown that this is not the case but I found some other interesting things that I need someone to explain to me. I have objects that implement my interface. I did three things 1) using a reference to a...
Hi all, I've got a django model that contains a manytomany relationship, of the type, class MyModel(models.Model): name = .. refby = models.ManyToManyField(MyModel2) .. class MyModel2(..): name = .. date = .. I need to render it in my template such that I am able to render all the mymodel2 objects that refer to mymodel. Cu...
It seems that on some of the servers that we have, the cost of hash joins, group by's and order by's is too low compared to the actual cost. I.e. often execution plans with index range scans outperform the former, but on explain plan the cost shows up as higher. Some further notes: I already set *optimizer_index_cost_adj* to 20 and it...
Hello, I've seen comments on SO saying "<> is faster than =" or "!= faster than ==" in an if() statement. I'd like to know why is that so. Could you show an example in asm? Thanks! :) EDIT: Source Here is what he did. function Check(var MemoryData:Array of byte;MemorySignature:Array of byte;Position:integer):boolean; var i:by...