Hello everyone, Working on improving performance of our decision center, one of the bottlenecks we identify is the DB. So I wonder, does oracle compiles an Execution Plan for it's views? Lets hypothetically assume I have a defined query being used 10000 times during a request. The query looks something like : select A, B, C from aTb...
I am looking to implement a very basic country limiting on my site based on the Maxmind geoip database (free version). Basically, I want to limit all users of the site to one country only. What I'm wondering is: is there any performance gain using the Apache API versus the PHP API? I want to be able to use the country code for more th...
Problem: I have a developers machine (read: fast, lots of memory), but the user has a users machine (read: slow, not very much memory). I can simulate a slow network using Fiddler (http://www.fiddler2.com/fiddler2/) I can look at how CPU is used over time for a process using Process Explorer (http://technet.microsoft.com/en-us/sysintern...
I've got a ruby script which takes about 30 seconds to startup. It takes that much because it tries to load all libraries and stuff. When I do "ruby.exe -v" it's instant. I don't want to touch the original ruby script, which is not written by me. What are the tricks to speed this process up? Can I precompile it? Can I precache al...
What are the most noticable differences between Google Protocol Buffers and ASN.1 (with PER-encoding)? For my project the most imporant issue is the size of the serialized data. Has anyone done any data-size comparisons between the two? ...
In an app with a small number of POJOs and lots of helper methods that operate on them, what's better performance-wise: to make the helper classes singletons or to make the methods static? ...
I'm curious to find out if anyone has some real world experience using Abinitio for data imports, manipulation, exports and if you highly recommend it. I'm looking to solve a scalability issue with this process and would like some feedback if it solved these problems. I've heard that it's a great tool for doing this. ...
Is there a cost in passing an object to a function that implements a particular interface where the function only accepts that interface? Like: Change (IEnumerable<T> collection) and I pass: List<T> LinkedList<T> CustomCollection<T> which all of them implements IEnumerable. But when you pass any of those to the Change method, are t...
I'm a game's developer and am currently in the processing of writing a cross-platform, multi-threaded engine for our company. Arguably, one of the most powerful tools in a game engine is its scripting system, hence I'm on the hunt for a new scripting language to integrate into our engine (currently using a relatively basic in-house engin...
I'm aware of the fact that Core Animation dispatches its animations in a seperate thread, as stated in the documentation. Nevertheless, my animations seem to be blocking my main thread. All animations start and finnish. (With or without kCATransactionDisableActions set as true.) but become jumpy and the main runloop stalls. What am I do...
I know the various frameworks have their benefits, but I personally want my web development in python to be as straight-forward as possible: less writing to the framework, more writing python. The only thing I have found so far that lets me do this in the most obvious way possible is web.py but I have slight concerns on its performance....
I've done several projects and packaged them into jar files, but I've noticed that my jar files run much more slowly than in my IDE. I use Eclipse to compile and run my programs. In Eclipse, I have everything working. When I package my project as a runnable Jar and execute it by double-clicking, everything still works. But when I have a...
I'm doing a raytracer hobby project, and originally I was using structs for my Vector and Ray objects, and I thought a raytracer was the perfect situation to use them: you create millions of them, they don't live longer than a single method, they're lightweight. However, by simply changing 'struct' to 'class' on Vector and Ray, I got a v...
I've been playing recently with Jython and decided to do some quick and dirty benchmarking with pystone. In order to have a reference, I first tested cPython 2.6, with an increasing numbers of loops (I thought this may be relevant as Jython should start to profit from the JIT only after some time). (richard garibaldi):/usr/local/src/pyb...
I am developing a web application that can support threaded comments. I need the ability to rearrange the comments based on the number of votes received. (Identical to how threaded comments work in reddit) I would love to hear the inputs from the SO community on how to do it. How should I design the comments table? Here is the structur...
If I have thousands of hierarchical records to take from database and generate xml, what will be the best way to do it with a good performance and less CPU utilization? ...
I'm re-building an IM gateway and hope to take advantage of the new performance features in AsyncSockets for .net35. My existing implementation simply creates packets and forwards IM requests from users to the various IM networks as required, handling request/ response streams for each connected users session(socket). i presently have...
Duplicate of What’s wrong with foreign keys? I use MS Sql Server with a large database about 4 GB data. I search around the web why I should use foreign keys. by now I only indexed the keys used to join tables. Performance is all fine, dataintegrety is no problem. Should I use foreign keys? Will I get even more performance with fo...
Here are some constraints for a data structure I need. It seems like none of the common data structures (I will mention the ones I've thought of below) fit these all that well. Can anyone suggest one that I maybe haven't thought of? I need to be able to perform lookups by unsigned integer keys. The items to be stored are user-defined...
We're about to start rebuilding one of our ASP.NET projects and I would like to try developing it without viestate turned on (disabled in web.config). I know about the upsides and downsides of viewstate and generally speaking what it keeps track of in comparison to control state, however I would like to know: What are the principle de...