At work, we have a large Perl application running to earn our keep. To read data from MySQL into perl application, there are a few ways to do that, and we wanted to compare performance of these methods.
- HandlerSocket, a NoSQL interfaceus, using Net::HandlerSocket) (columns selectable)
- DBI, the standard Perl database interface (using DBD::mysql underneath) (columns selectable).
- HANDLER DBI, DBI queries, using HANDLER statements instead of SELECT statements. See HANDLER Syntax (full rows