I recently launched my humble side project and would like to add a "related submissions" section when viewing a submission. Exactly like what SO is doing here - see right column, titled "Related" Considering that each submission has a title and a set of tags, what is most effective (optimum result), most efficient (fast, memory friendly...
I'm looking for some advice on how to optimise the following process: App reads csv file. For each line in the file an XML message is created Each XML message is posted to a URL via a HTTPWebRequest This process was designed to handle low volumes of messages (up to about 200 at a time), un suprisingly thinks have changed and it is now ...
Goal: Suggest objects based on user's choices Data: Table containing info on how users would order a subset of objects from the worst to the best; Example: 1 2 3 4 5 6 John: A B G J S O Mary: A C G L Joan: B C L J K Stan: G J C L There's about 20 times as many users as objects, every user's lineup contains 5...
I was curious about the performance of insert-sort using C and python but the results I've got just make me think if I've done something wrong. I suspected that C would be faster, but not that much. I've profiled both codes and the insert-sort function is the place where the time is most spent. Here is the C function: void insert_sort...
Hi, I'm working on a basic php/mysql CMS and have a few questions regarding performance. When viewing a blog page (or other sortable data) from the front-end, I want to allow a simple 'sort' variable to be added to the querystring, allowing posts to be sorted by any column. Obviously I can't accept anything from the querystring, and nee...
I have a SQL statement to select results from a table. I need to know the total number of records found, and then list a sub-set of them (pagination). Normally, I would make 2 SQL calls: one for counting the total number of records (using COUNT), the other for returning the sub-set (using LIMIT). But, this way, you are really du...
I have a sqlite database where all the primary keys are GUIDs. Currently they are stored as fixed length strings but I want to store them as blobs because it simplifies the code for storing and retrieving data. I converted part of the database and everything is functioning as expected. However, I'm not sure if I will run into performa...
I'm using IronRuby 0.9.1 and cucumber 0.4.0. I also have MRI 1.8 installed. I've created the following wrapper script (icucumber.bat) to run cucumber on IronRuby @ECHO OFF REM This is to tell IronRuby where to find gems. SET GEM_PATH=c:\ruby\lib\ruby\gems\1.8 @"C:\ironruby\bin\ir.exe" "c:\ruby\bin\cucumber" %* Navigating to cucumber-...
Hi, I've the following method (SPIN) that select 7 values (taken from an array) into my multi-cols pickerview. for(int i = 0; i < 7; i++) { int newValue; newValue = [[array objectAtIndex:i] intValue]; [picker selectRow:newValue inComponent:i animated:YES]; [picker reloadComponent:i]; } The problem here is that while it...
I often read that using CALayer rather than UIImageView is an performance boost when it comes to heavy image usage. That makes sense, because UIImageView causes 3 copies of the image in memory, which is needed for Core Animation. But in my case I dont use Core Animation. How could I assign an UIImage (or the image data of it) to an CALa...
I'm developing a grid with excel-like functionality using the telerik controls. For example users can click on a cell and the cell turns into an input control for editing. Users can tab to move onto the next cell or use arrow keys for up/down to get the cell above or below. I've found the standard telerik grid is good but I've had to ext...
For testing the capabilities of an animation class I have created 5000 fullscreen images with 100kb size each. I added just 1000 of them to my project and Xcode is already building for 30 minutes now. The next time it would be nice if Xcode just uses the already alpha-premultiplied images from a previous build instead of stupidedly rebui...
I've been reading an article about caching images in iPhone OS, and they pointed out this code snippet: NSData *urlData = [NSData dataWithContentsOfURL:aURL]; When I do something like this, does the whole big image data get sucked into the memory? Or will the image data go into memory as soon as that urlData object is actually used? R...
After working with different data sets in SAS for a month or two, it seems to me that the more variables a data set has, the more time it takes to run PROCs and other operations on the data set. Yet if I have for example 5 variables, but 1 million observations, performance is not impacted too much. While I'm interested in if observatio...
If I want to become a Performance Consultant for Java applications and systems, what are the main skills I need? long experience with Java itself using a Profiler (or StackShots) database knowledge (to avoid/detect common performance mistakes : indexes...) Caching library Java concurrency Do you agree on the importance of these? What...
I need some C++/pointer help. When I create an RGB IplImage and I want to access i,j I use the following C++ class taken from: http://www.cs.iit.edu/~agam/cs512/lect-notes/opencv-intro/opencv-intro.html template<class T> class Image { private: IplImage* imgp; public: Image(IplImage* img=0) {imgp=img;} ~Image(){imgp=0;} ...
Hello, I have another drag-and-drop question. I'm using DnD on a Tree component and it works fine, when I have up to 50-80 items in the tree. However, when I have 100-300 items, the simple drag-and-drop operation suddenly eats all my CPU capacity and the application freezes for up to 1 minute. I suppose that happens because Flex is tr...
I've inherited a database with a surprisingly high number of unused sprocs. I've extracted the names of the used sprocs from the DLL that access it (all access is via that DLL), and from EXEC statements in those sprocs, and there are a couple hundred that are not called. Further, almost all have suspiciously verbose, uniform names: I sus...
Hello stackoverflowers, I have a straightforward question. I am doing a web application that uses MySQL, and I am currently designing it. I just have a small question about performance. I would like to know what is more efficient: Scenario #1: Table: Restaurant -Name -City -Province -Country -Continent sql =...
Hi, Incase if you are to develop twitter today what language, tools and approach will one take. How will he start from the very frugal configuration and gradually scale to the levels twitter has reached today. Incase if you can provide direct responses like (PHP+ Apache+ memchached+ MySQL) or (JSP+TomCat/Glassfish+ MySQL / other db) et...