Beavidy

I'm using Rails 8 with
gem "activerecord-sqlserver-adapter", "~> 8.0", ">= 8.0.1"
gem 'tiny_tds', '~> 3.0.0',

I have have a postgres db on Render and my company has s Sqlerver db on Azure. Any thoughts on why i would get this from Sqlserver:
10:11:07 web.1 | JobScopeTaskTime Load (40.5ms) SELECT [job_scope_task_times].* FROM [job_scope_task_times] WHERE [job_scope_task_times].[job_scope_task_id] = 436 /action='show',application='Hme',controller='job_scopes'/

and this form Postgres:
10:15:08 web.1 | JobScopeTaskTime Load (0.1ms) SELECT "job_scope_task_times".* FROM "job_scope_task_times" WHERE "job_scope_task_times"."job_scope_task_id" = 188 /action='show',application='Hme',controller='job_scopes'/

That's 40ms for Sqlserver and 0.1ms for PG. The application is essentially useless when run with my companies Azure database. I do know that it is a S0 tier sql database and a Pro-4gb tier PG database on Render. They should be similar in 'power'.

importmaps

I'm using Heroku. But now I'm just trying to get it up and running locally in production before trying to deploy again.

I am using Rails 7 with importmap, everything works fine in development, but in production none of the javascript works. Specifically, my channels files are of the "wrong MIME type" giving a 404, and none of my bootstrap dropdowns work. I haven't even tried the rest, but I'm assuming there is something silly I'm missing and everything will fall into place once i correct that. I've tried clobbering, precompiling, changed relative paths to direct paths. I'm at a loss. Any help is greatly appreciated!