I'm working with big data. I've written extra slow query. I hope there are ways to make it faster.
Query:
CREATE TEMPORARY TABLE tmp_table AS
SELECT bg2.id, bg1.property4
FROM big_table bg1
JOIN correlating_table cor
ON kuf1.property4 = cor.id1
JOIN big_table bg2
ON bg2.property4...
I would like to know if there is a more optimal/efficient way of having some of my functions run on a different thread. When a user clicks a button, the program will either:
Scan the current directory and all directories below for files.
Save calculated checksums for all files to a sentry file
...
Reviewing the tested method:
public void ResetColours(Colours colour)
{
var colourInfo = colour.GetInfo();
for (int i = 0; i < 9; ++i)
this.SetColourInfo(i, colourInfo);
}
The colour parameter is singular, but its type is plural. Either colour stands for many colors and it's ...
The general question is are there alternative patterns to AAA for unit testing?
If, yes, would be very interesting to see some examples and hear about their pros and cons.
And as the simplest example of AAA test (in c#, using var for the sake of simplicity):
// Arranging
var annualSalary = 1200...
In the comment to this great post Roy Osherove pointed to the OAPT project that is designed to run each assert in a single test.
This is written on projects home page:
Proper unit tests should fail for
exactly one reason, that’s why you
should be using one assert per unit
test.
And ...
This program trims the white spaces from the string in O(N) complexity. But the problem is it trims only one white space. How could It be improved to trim multiple white space keeping the same complexity.
Any solution?
/*remove space, only one space*/
void RemoveSpaces(char* source){
char* i =...
I am a a big fan of one-liners using sed awk perl and other tools. But there are things hard to do in one-liner like when you working with a CSV file and there are comma between quotes, or when you want to print a centralized field with printf.
Few months ago I wrote ftable more for fun than any...
Just looking for some review for my code. this is a script that checks for outbound links in posts in vBulletin forums, and if it is an external link it will redirect to a template which will load the external site in an iFrame that I also coded, inspired by themeforest and stumbleupon's way of ...
In this project (C# Win forms) I'm supposed to calculate wages of employees. So these are the steps...
Calculate earnings from Attendance data. Here all regular earnings like BasicSalary, OverTimeAmount etc will be calculated.
Then these earning details will be shown in a grid where user can en...
class Person(object):
def __init__(self, name):
self.name = name
def speak(self):
print "Hello, this is {}!".format(self.name)
class Dog(object):
"""
Adaptee
"""
def __init__(self, breed):
self.breed = breed
def bark(self):
print "w...
This question here: Shortest possible way of printing a specific board
Summary:
The code requirement is to print out a grid of text.
The code does in fact print the grid
The way it does that, is very broken, and it is only by hacking things that it works.
From a code-review perspective, it doe...
If you talk purely about "is code working", then I presume you do not take a specific CodeReview approach to that problem. Hence "is the code working" should be approached as a black box. You put stuff into the program, it spits correct pieces out. Hence the code is working.
Now we are here at C...
