To start with some context, I'm so annoyed whenever I get on a Windows computer that has the settings adjusted for "best appearance" over "best performance" that I instinctively turn off all fades, transitions, animations, etc. immediately. I almost can't focus until it's changed. However, when it comes to my web apps, I will very occas...
I have a website that has user ranking as a central part, but the user count has grown to over 50,000 and it is putting a strain on the server to loop through all of those to update the rank every 5 minutes. Is there a better method that can be used to easily update the ranks at least every 5 minutes? It doesn't have to be with php, it...
I am working on optimizing my site, and I have had the MySQL slow queries log on for a few days now, but after going through >260M queries, it only logged 6 slow queries, and those were special ones executed by me on phpMyAdmin. I am wondering if there is something to log slow PHP page execution time so that I can find certain pages tha...
I have a mysql (5.0.22) myisam table with roughly 300k records in it and I want to do a lat/lon distance search within a five mile radius. I have an index that covers the lat/lon fields and is fast (milisecond response) when I just select for lat/lon. But when I select for additional fields in the table is slows down horribly to 5-8 ...
How can i test webpage/app rendering for slow speed connection? ...
Consider the following C# code: IEnumerable numbers = Enumerable.Range(0, 10); var evens = from num in numbers where num % 2 == 0 select num; Is this pure syntactic sugar to allow me to write a for or foreach loop as a one-liner? Are there any compiler optimizations under the covers that make the list comprehension above more efficien...
Hello, Similar to xdebug+webgrind which gives us the rough time for execution for each function in a file etc, I am wondering how to go about optimizing as well as detecting slow javascript functions. Am sure firebug can probably do this, but am not sure how? Can someone guide me as to how to detect memory leaks also? How do I decide ...
Hey guys. This is a follow-on from this question: After getting the right data and making some tweaks based on requests from business, I've now got this mini-beast on my hands. This query should return the total number of new jobseeker registrations and the number of new uploaded CV's: SELECT COUNT(j.jobseeker_id) as new_registrations,...
Does there exist a collection, that is aware of shared_ptr internals, and avoids regular copying of stored shared_ptr elements in favor of just copying their internal weak pointer? This implicitly means, that no constructor/destructor calls will be done and that there will be no manipulation of shared_ptrs' reference counters. ...
I was wondering if it's faster to process data in MySQL or a server language like PHP or Python. I'm sure native functions like ORDER will be faster in MySQL due to indexing, caching, etc, but actually calculating the rank (including ties returning multiple entries as having the same rank): Sample SQL SELECT TORCH_ID, distance AS t...
The question dealing with Visual Studio optimizations saved me so much time firing it up and using it I have a hard time going back to Eclipse when I have to do J2EE development. Hence, I was also wondering if people have any tips or tricks to help speed Eclipse up in day to day use. For information, I'm using the Eclipse version 3.4.1...
Hi all, I am a fairly new MySQL developer and am starting on a project that I could do with a bit of initial advice on... I am creating a database that will primarily be holding a certain number of items (between 1-5k) and around 40 boolean variables associated with each one. Users will then be inputting their choice of these 40 value...
Is there any way to compress an html page or html output of asp.net page to make them load faster. I heard that Google is using that technology someway. Thanks in advance. ...
I was wondering if anyone has any strategies for optimizing the pre-loading of images via javascript? I'm porting a Flash application into html/css, attempting to recreate the UI as close to the original site as possible. It's essentially a photo browser application, where a high-res image is shown when the user hovers over a link. Ther...
I'm looking for tools and approaches to determining what parts of of my Cocoa and Cocoa-Touch programs are most contributing the the final binary image size, and ways to help reduce it. I'm not looking for a "magic bullet" compiler flag. I'm looking for profiling techniques for evaluating and reducing image size waste in the same vein as...
glCallLists() is a convenient function for rendering a series of display lists, especially for things like text rendering. I'm curious -- is it actually more efficient to call glCallLists(), or is it merely a convenience function? For example, which of these two snippets is likely to be faster? const char *str = "this is a test"; // s...
First question on stackoverflow. I have no previous experience of running a high traffic website and I would consider myself somewhere in between a novice and an intermediate programmer....please be gentle :) I am trying to make a social website that I ultimately hope will handle a lot of traffic and users. However, I don't know if the...
I have a large number of instances of a C structure like this: struct mystruct { /* ... */ unsigned flag: 1; /* ... */ }; flag is initially 0 but must be 1 on exit from a certain function. The simplest implementation is: void set_flag(struct mystruct *sp) { sp->flag = 1U; } But what is the likely effect on perfor...
Reviewing code, I came across a number of new Private Shared variables (of type Hashtables(Of String), initialized in the declaration) added to a partial class for a very large (DataContext-derived) class. This seems sensible to me in one sense because they never change, and making these shared variables ensures that they won't get re-i...
I have a solution with several projects in it. Let's say project A depends on projects B and C project B depends on project C When I run my solution on the local machine VS builds each project once and it takes 1 minute. However, on our build machine it takes about 4 minutes to build and, as I can understand from the MSBuild logs it g...