Re: How does FreeTDS support bulk export
"Thompson, William" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <4A990489BF566041A7724DC577BB060417F44F8B@smtp_mail.bankofamerica.com> |
Hi Johnny, What is this "bulk export" you refer to? If there's INSERT statements going on, it sounds more like an import to me... What is wrapped around FreeTDS in your application? I think it's more likely that it's this that is deciding on the approach of generating multiple INSERT statements, rather than FreeTDS. Bill -----Original Message----- From: FreeTDS [mailto:[email protected]] On Behalf Of Johnny Yan Sent: 09 August 2016 23:29 To: [email protected] Subject: [freetds] How does FreeTDS support bulk export Hi, We've observed, through the freetds.log, that when we try to bulk export multiple rows, what FreeTDS really does is replacing the ? placehold with the corresponding param value(s), then concatenating multiple "INSERT INTO..." statements into a single query, and finally sent it through the wire. Is this what we're supposed to expect? How does FreeTDS support bulk export? Thanks, Johnny _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds ---------------------------------------------------------------------- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message.