Home Forums Programming General SQL Design Patterns and Refactoring? RE: SQL Design Patterns and Refactoring?

  • I hope that everybody knows what RBAR stands for.

    Our off-shore team managed to invent CBAC: column behind agonizing column; Well not quite - for a record with n columns they managed to create a n-1 stored procedures/dynamic SQL that retrieves one column value for a given primary key (record identifier).

    So if they need to get a recordset with let's say 10 records from a table with 11 columns they CAN DO it in 100 calls!