With a script that's being run about once a day that imports a lot of data I'd like to disable indexes temporarily since thousands of lines get imported once a day.
How do I set session variables since I presume the connection pool uses multiple sessions at once? For instance, how do I work this in to my Sequel queries before running a ton of inserts: SET FOREIGN_KEY_CHECKS = 0; SET UNIQUE_CHECKS = 0; SET AUTOCOMMIT = 0; -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/J5Exv_7YCpwJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
