We are running a stats site for a bunch of games, but after the log has tipped over 100 megs, things are starting to slow down, so we need to optimize our queries. However, we've found out that what we thought was a simple query, takes about 1.5 secs: SELECT handle, ( SELECT COUNT(*) FROM kills WHERE killer=p.handle AN...
I am interested in ways to stress-test as well as benchmark the SANOS operating system kernel. ...
WS-DM is a web services equivalent of JMX. I am looking for an open source implementation... ...
Dear All, I need to get CPU utilization metrics for all the threads in a process. Operating system = Redhat linux programming language = C++ using POSIX requirements = need to take samples every few seconds indefinetly, not just for one snapshot in time. constraints = not allowed to write additional code in thread I know you can u...
If I just want to do a quick measurement of how long a particular function is taking, what can I call to get an accurate timing? Given that the VB6 timing functions aren't high precision, are there Windows API functions you call instead? In what other ways do you measure application performance? Are there any third-party tools that you ...
I want to maintain last ten years of stock market data in a single table. Certain analysis need only data of the last one month data. When I do this short term analysis it takes a long time to complete the operation. To overcome this I created another table to hold current year data alone. When I perform the analysis from this table it...
It is recommended that js files be included on the bottom of the page. I'm using Telerik Rad Ajax controls that emit js includes on top of the page. Is there a way to force it to emit js includes at the bottom of the page? ...
Hi all, I've just finished my entry for the 14th Ludum Dare 48-hours game making competition yesterday, and decided to do it in java using java2d for the graphics. I'm not that familiar with the API and haven't done a lot of graphics programming, but my game is quite small (only a dozen or so very small moving object) so I assumed I c...
I have a very high-traffic table with a char(50) field which takes part in several indexes. This char(50) field allows NULLS, and in that case a NULL value is considered to be the same as a non-NULL, zero-length string for my purposes. I also disregard leading & trailing whitespace and, while I scrub the data before I insert it, it may...
In a game I'm making, I've got two points, pt1 and pt2, and I want to work out the angle between them. I've already worked out the distance, in an earlier calculation. The obvious way would be to arctan the horizontal distance over the vertical distance (tan(theta) = opp/adj). I'm wondering though, as I've already calculated the distanc...
Which is better( or faster) c++ for loop or the foreach operator provided by Qt? For example,the following condition QList listofstrings; Which is better? foreach(QString str, listofstrings) { //code } or int count = listofstrings.count(); QString str = QString(); for(int i=0;i<count;i++) { str = listofstrings.at(i); //code } ...
This is a canonical question, meant only half-way as a joke. Hopefully, you'll find this before posting any question of the form: Is something faster than something else? Hopefully, the answers below will educate you and prevent you from asking any such questions. Make sure you answer it, bods. I've posted my own thoughts but I've...
Which SQL would be faster to validate if a particular column has a null value or not, why? 1) SELECT * FROM TABLE1 WHERE COL1 IS NULL Execute this query and then check if you are able to read any records. If yes there are null values. 2) SELECT COUNT(COL1) FROM TABLE1 WHERE COL1 IS NULL Read the count which is returned to determine i...
I'm working on a rather large classic asp / SQL Server application. A new version was rolled out a few months ago with a lot of new features, and I must have a very nasty bug somewhere : some very basic pages randomly take a very long time to execute. A few clues : It isn't the database : when I run the query profiler, it doesn't det...
Most of SQL queries have no math operation on where clause. What is wrong having them on 'where clause'? Is there any performance issue? Eg: SELECT * FROM Employee WHERE Salary*3 = 5000 ...
I am trying to decide between two possible implementations and am eager to choose the best one :) I need to add an optional BLOB field to a table which currently only has 3 simple fields. It is predicted that the new field will be used in fewer than 10%, maybe even less than 5% of cases so it will be null for most rows - in fact most of...
Writting an asp.net shopping cart. I am leveraging the session for state but I also want to store basic info in a cookie. This info would be the items / qty. I am aware of the cookie size limitations but here the question. Are there any sources of information on performance cost in terms of writting to a cookie as opposed to sql. In my ...
Is there a way to improve performance in any meaningful way for the following VBA code in Excel? Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Me.Range("Group1"), Target) Is Nothing Then With wksData .Range("Group1Column").Value = Target.Column .Range("Group1Row").Value = Target.Row...
I have a database where I need to query to get records from one table and then lookup on another table to see if that value exists there. That table might return multiple records and I want the one with the most recent date. So table 1 is basically: ID (Primary Key) Name Test_Score And Table 2 is Test_Id (Primary) Student_ID (Forei...
Given a time (eg. currently 4:24pm on Tuesday), I'd like to be able to select all businesses that are currently open out of a set of businesses. I have the open and close times for every business for every day of the week Let's assume a business can open/close only on 00, 15, 30, 45 minute marks of each hour I'm assuming the same sche...