Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^4: Skip problematic lines while populating database

by perlfan (Vicar)
on Aug 17, 2020 at 16:08 UTC ( #11120835=note: print w/replies, xml ) Need Help??


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

This node falls below the community's threshold of quality. You may see it by logging in.
  • Comment on Re^4: Skip problematic lines while populating database

Replies are listed 'Best First'.
Re^5: Skip problematic lines while populating database
by dave_the_m (Monsignor) on Aug 17, 2020 at 17:38 UTC
    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.

      I didn't say not to use placeholders.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11120835]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (3)
As of 2022-05-19 09:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (71 votes). Check out past polls.

    Notices?