Ken Collins comments

Results 340 comments of


                                            Ken Collins

Insert multiple rows in a single command

Cool... but if it does not work and `sp_executesql` does then what you are really trying to say is that bytes sent on the wire is the high bar for...

Insert multiple rows in a single command

> That's the only part I'm missing. I think I'm missing more... like specifically how TinyTDS can do this when we use DBLIB? > SQLServer can handle inserting many records...

Insert multiple rows in a single command

Thanks, it would be super helpful to understand perf more with measured data. Do you have a blog post that someone else has done on this? Anything would be interesting...

Insert multiple rows in a single command

Cool, thanks. I did a write up with some simple benchmarks using `sb_executesql`. https://blog.engineyard.com/2011/sql-server-10xs-faster-with-rails-3-1 What would be really cool is to understand if Ruby ODBC or some apples to apples...

Insert multiple rows in a single command

> There should be a way that I can make one sp_execute call, specify the prepared statement @handle and send some sort of array of values. But I couldn't figure...

Insert multiple rows in a single command

Maybe related, see this thread/post. https://github.com/rails-sqlserver/tiny_tds/issues/360#issuecomment-309252072

missing row_set with mutiple result sets

Thanks, the second example before your "BUT:..." does not seem to be inline with what I expect in the docs readme (https://github.com/rails-sqlserver/tiny_tds#readme). Please see the section that starts with "The...

Proposal: Allow Setting @query_options per Client

Sounds OK to me.

TinyTds::Client.new blocks other threads

I would think expected behavior for Ruby and compared to other DB connection gems. You can lower the connect timeout if you want.

TinyTds::Client.new blocks other threads

Cool, if you find that other DB connection gems behave differently, please do let us know so we can make this better.