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

30th
Jul 2017
Joe Bauser
@coderjoe
Jul 30 2017 01:55
@metaskills If you need anything I'll be on gitter for the next hour or two while I watch a movie.
Ken Collins
@metaskills
Jul 30 2017 13:55
Working on builds now...
v2.1.0.pre1 gem pushed.
Ken Collins
@metaskills
Jul 30 2017 14:00
rails-sqlserver/activerecord-sqlserver-adapter#611
Will watch this.
Ken Collins
@metaskills
Jul 30 2017 16:31
OK... so maybe we let pre1 bake a few days then we release v2.1.0 final?
Joe Bauser
@coderjoe
Jul 30 2017 16:36
Sounds good to me.
Dan Corneanu
@dan-corneanu
Jul 30 2017 21:23
Hello everybody. Where is the best place to ask a question related to a performance issue I am struggling with? activerecord-sqlserver-adapter + tiny_tds + FreeTDS + SQL Server on a local windows machine
Joe Bauser
@coderjoe
Jul 30 2017 21:24
Here is a good bet though it may be a while before someone can respond. I'm out and about not near a PC.
Dan Corneanu
@dan-corneanu
Jul 30 2017 21:31
ok, I'll give it a try. So I am trying to improve the performance of a piece of code that needs to insert ~3000 records in the database. I know that the best option is to use bulk inserts, but before I start doing changes I though I should just measure how long it takes to insert them one by one using raw SQL thus bypassing ActiveRecord. So I have set up a test and run it against a postgresql instance running on the same machine and got ~6906.841934196261 inserts / s which is not bad for my needs. However, if I run the same test against an SQL server installed on a Windows machine on the same intranet I get ~506.41719571221114 inserts / s which seems to me very low even if I account for the fact that the sql server is accessed via a local network
now, the question is how can I check if the problem is with the network delay or is is something else ?
I have to add that one test is using the PostgreSQLAdapter and the other one is using SQLServerAdapter and all the test does is executing a bunch of
result = ActiveRecord::Base.connection.execute(sql_statement)