[thelist] MySQL oddness

r937 rudy at r937.com
Tue Jan 29 16:14:40 CST 2008


> Or are you suggesting that the database will perform
> a projection even if the column list is the full set?

<voice character="Sgt. Schultz">
   i suggest nossink!!
</voice>

(Hogan's Heros -- maybe you're too young)


first, the database has to retrieve the row

next, it's gotta move da shiznitz from da database buffer to da output 
buffer

u tell me whether a row-by-row move in memory is faster than a 
field-by-field move in memory

and by how much   ;o)

sorry, i dunno why i wrote "u" (mebbe i'm just ornery this aft)



rude bwoy








More information about the thelist mailing list