These are chat archives for rails-sqlserver/activerecord-sqlserver-adapter

5th
Jun 2017
gerome0123
@gerome0123
Jun 05 2017 00:19
how to load 6k client in my combobox in the fastest way???
Eric Hansen
@ehansen486
Jun 05 2017 18:40
Hi- wondering if anybody has used tiny_tds to insert a lot of records (osx/freetds 1.00.40). I tried doing this via multiple values statements, but it's incredibly slow in SQL*Server. I tried sp_prepare, but am not sure how to leverage that for multiple rows
INSERT INTO MyTable (id, name) VALUES (1, 'Bob'), (2, 'Peter'), (3, 'Joe');
works, but is really slow with lots of rows/columns