I see a lot of debate going back and forth on which language to use to develop real-time 3D games, and the general consensus is that C or C++ are the only languages that can offer suitable performance for high-end, system-intensive 3D games. I see a lot of people saying C#, Java or Python are too slow, particularly because of garbage col...
My Question: Performance tests are generally done after an application is integrated with various modules and ready for deploy. Is there any way to identify performance bottlenecks during the development phase. Does code analysis throw any hints @ performance? ...
I have a UIScrollView where a lot of objects appear (UIImageView's) during scrolling. However, when the user is scrolling, I want to fire messages to all these objects, in order to tell them that they shall not do anything stupid. When the UIScrollView decelerates, some animations happen at the visible objects. When the user moves on fas...
I have a small iPhone app that stores a list of objects. The user can add and remove objects, but this list will remain fairly small (most users would have 10-30 objects). NSUserDefaults seems much easier to work with, but will sqlite3 be faster? With only 30 "records" will there be any noticeable difference? ...
I am currently into a performance tuning exercise. The application is DB intensive with very little processing logic. The performance tuning is around the way DB calls are made and the DB itself. We did the query tuning, We put the missing indexes, We reduced or eliminated DB calls where possible. The application is performing very well...
When you derive from a class and instance the subclass, the runtime also instances the super class, right? Since abstract classes can't be instanced, are they not created by the runtime when a subclass is instanced? If so, then abstract class inheritance would be faster than normal class instance? ...
Hi, I'm a noob and wrote a whole program without knowing the easy way to find an element in an array... my_array.indexOf("find this value"); Is indexOf a lot better than storing how many elements are in an array, and looping through the array until you find the element you want? I could have simplified my code alot. I tried to make ...
I'm always using an output variable in PHP where I gather all the content before I echo it. Then I read somewhere (I don't remember where, though) that you get best performance if you split the output variable into packets and then echo each packet instead of the whole output variable. How is it really? ...
I'm overloading a vb.net search procedure which queries a SQL database. One of the older methods i'm using as a comparison uses a Stored Procedure to perform the search and return the query. My new method uses linq. I'm slightly concerned about the performance when using contains queries with linq. I'm looking at equally comparable que...
I've written a query to look for indexes that are not used in the production environment in order to drop them, however I'm curious whether the last_user_update column is an indication that the index was solely a maintenance overhead, in which case it would be good to drop it, or whether the index helped the performance of the insert/upd...
I know how to get CPU usage and memory usage for a process, but I was wondering how to get it on a per-thread level. If the best solution is to do some P-Invoking, then that's fine too. Example of what I need: Thread myThread = Thread.CurrentThread; // some time later in some other function... Console.WriteLine(GetThreadSpecificCpuUs...
DB Table: id int(6) message char(5) I have to add a record (message) to the DB table. In case of duplicate message(this message already exists with different id) I want to delete (or inactivate somehow) the both of the messages and get their ID's in reply. Is it possible to perform with only one query? Any performance tips ?.....
I was under the impression that FastCGI allowed you to kinda load in your web app once, and then you just "provide" FastCGI with some function, like myHandleHTTPRequest($url), that would then be called whenever a request came. This way you'd get much better performance as your app is ready in memory all the time, right? But I'm starting...
I have received perfmon counters from customer site. We noticed unusual values in \COMPUTERNAME\Process(PROCESS_NAME)**IO Other Operations/sec**. The best explanation for the counter I came up with is:- The average rate at which the process is issuing I/O operations that are neither read nor write operations (for example, a co...
I have this query: select distinct id,name from table1 For a given ID, the name will always be the same. Both fields are indexed. There's no separate table that maps the id to the name. The table is very large (10 of millions of rows), so the query could take some time. This query is very fast, since it's indexed: select distinct...
Anyone knows if multiply operator is faster than using the Math.Pow method? Like: n * n * n vs Math.Pow ( n, 3 ) ...
Some users are reporting that my site is too slow And i think background images in css might be a possible culprit I have a site that uses a custom build system to concatenate all css, compress them ( yui compressor ) , make css sprites automatically ( smartsprites ) and I end up with a 9kb CSS for the whole page, this includes all cs...
I have seen a question on why "polling is bad", but I am wonderring, in terms of minimizing the amount of processor time used by one thread, would it be better to do a spin wait (i.e. poll for a required change in a while loop) or wait on a kernel object (e.g. a kernel event object in windows)? For context, assume that the code would be...
Which is more efficient,and by how much? type 1: insert into table_name(column1,column2..) select column1,column2 ... from another_table where columnX in (value_list) type 2: insert into table_name(column1,column2..) values (column1_0,column2_0..),(column1_1,column2_1..) The first edition looks short,and the second may become ex...
I did recently attach the 3rd version of Dijkstra algorithm for shortest path of single source into my project. I realize that there are many different implementations which vary strongly in performance and also do vary in the quality of result in large graphs. With my data set (> 100.000 vertices) the runtime varies from 20 minutes to...