Hi, I am new to ruby/sequel, work in different field: .Net, Go. I came across a need to make fluentD to insert json to MSSQL to support some legacy systems. Decided to write a plugin for fluent, hello Ruby…
I end up make the things working but I centered everything upon multi_insert logic that generates many INSERT INTO()VALUES() statements. Well, it is many thousands events/s and it is not good for DB to do it. So, I need some kind of bulk operation. Ideally I would like to call a scpoc on SQL side and to use table valued parameter (TVP), make the actual insert at back-end engine side, jointing instead of looping. I was looking the documentation for sequel and it does not look the library supports TVP datatypes. Would you guys please confirm it? If not TVP then what other options I have to drive a lot of data in BUKL to DB with sequel? Thank you. -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
