http://www.perlmonks.org?node_id=11120846


in reply to Re^4: Skip problematic lines while populating database
in thread Skip problematic lines while populating database

Given that the code needs to handle 60Gb of data, it seems to me that having a couple of extra lines in the code to optimise things would be called for in this case. An even if it didn't need optimising, using placeholders automatically gives correct quoting of fields, so the code won't die just because a field contains a single quote character.

Dave.