Na zamyslenie... :-)

[Delphin]

>  Jejda, tak sem to samozrejme nemyslel :o) Ale spousta aplikaci vznika
"naklikanim" v nejakem vyvojovem prostredi bez > jakekoliv optimalizace a
pak to podle toho vypada.

Naklikani jeste nemusi nutne znamenat pomalou aplikaci. Spise jde o tu
optimalizaci.

Abychom nechodili kolem horke kase, tady je nazorny priklad, proc jsou
aplikace tak pomale:


<http://TheDailyWTF.com/archive/2004/09/01/1511.aspx>

Rajah Donalt sends in a stored procedure he came across in a production
system. I'll bet you didn't know that this is the fastest way to select a
row from a table from a primary key. At least, according to the author of
the procedure.

CREATE PROCEDURE sp_get_order (

@OrderID int

) AS

select * into #temp_order from Orders

delete from #temp_order where OrderID<>@OrderID

select * from #temp_order

drop table #temp_order

[Table and column names have been changed to protect the innocent]