Search Result

krishnaroopa · Jan 13 '11, 10:40 AM

I have a sequence of 20 stored procedures executed to produce the final output. In almost all procedures, i have a table lookup. The query is something similar to shown below:

Code:

SELECT *
FROM tableA 
WHERE
ISNULL(col1, @col1) = @col1 AND
ISNULL(col2, @col2) = @col2 AND
ISNULL(col3, @col3) = @col3 AND
ISNULL(col4, @col4) = @col4 AND
@col5 BETWEEN ISNULL(col5, @col5) AND ISNULL(col5, @col5)

...

Arpit Tarang · Aug 25 '10, 07:40 PM

This came in a competition:
There is a rectangular grid of coins, with heads being represented by the value 1 and tails being represented by the value 0. You represent this using a 2D integer array table (between 1 to 10 rows/columns, inclusive).

In each move, you choose any single cell (R, C) in the grid (R-th row, C-th column) and flip the coins in all cells (r, c), where r is between 0 and R, inclusive, and c is between 0...

Pooria · Jul 21 '10, 08:13 AM

take two following classes and their constructors as samples:

Code:

class One{
 public:
  One(int a,int b):adad1(a),adad2(b){}
 private:
  int adad1;
  int adad2;
};
class Two{
 public:
  Two(int input[]){
   for (int i=0;i<10;i++)
    araye[i]=input[i];
  }
 private:
  int araye[10];
};

considering objects with static...

Pooria · Jul 21 '10, 08:10 AM

How does an optimizing c++ compiler determine when a stack slot of a function(part of stack frame of a function) is no longer needed by that function, so it can reuse its memory? .
By stack slot I mean a part of stack frame of a function, not necessarily a whole stack frame of a function and an example to clarify the matter is, suppose we have a function that has six integer variables defined in its scope, when it's time to use sixth variable...

Niheel · Jun 3 '10, 04:26 AM

We have a table with 2 million plus records and we need to paginate through it at 100 records at a time.

What is the best way to approach this while keeping server load and overhead cost down?

Looking for any solution:
different query types
caching
mysql settings
hardware recommendations
indexing

ddmetro · Sep 21 '09, 11:32 AM

Hi All,
Our project is to optimize gcc's instruction scheduling. It requires us to specify architecture information
(basically number of cycles per instruction, stall and branch delays)
to gcc, to optimize structural hazard detection.
Problem: Is there any specific format in which we can specify this
information to gcc? Is it possible to embed this additional
architecture specific detail, in .md...

Search Result

Query optimization - where - ISNULL

Coin flipping game: Optimization problem

which kinds of constructors may be applied during compile time as optimization.

how does an optimizing c++ compiler reuse stack slots of a function?

How to decrease pagination query time when dealing with 2 million + records

how to specify architecture information to gcc