June 18, 2013

Post: MySQL Prepared Statements

MySQL 4.1 there were only textual statements and textual protocol for data transfer – query was sent as text and result returned… implication – queries had to be parsed fully each time, all return values had to be converted to the strings on server… statements – Many memory leaks reported in MySQL Server turned out to be prepare statements or cursors which were forgotten to be closed…