Model binding slow post migration to Oracle 19c
Posted: Thu 17 Mar 2022 12:21
Hi everyone,
I'm in the process of migrating our backend from Oracle 11g to 19c. During testing I noticed that one of our DB calls has slowed down somewhat. On the older 11g schema, the call took around 2 seconds to run and return results, where as the new 19c schema the call takes between 10-15 seconds to finish running. It's a very simple select statement and running the same statement directly in TOAD takes under a second to return 7 records.
After further testing, I've concluded it only happens (or most notably) when model binding is used.
When making a call using OracleCommand("SQL statement here") the results come in nice and quick. I can't however explain why the change from 11g to 19c would cause model binding to slow down so much. Does anyone have any ideas on how I might improve the performance?
Specs:
c#
.NET 4.52
Devart.Data v5.0.1431.0 (runtime v2.0.50727)
Devart.Data.Linq v4.5.976.0 (runtime v2.0.5027)
Devart.Oracle v9.0.7.0 (runtime v2.0.5027)
Devart.Oracle.Linq v4.5.976.0 (runtime v2.0.5027)
I'm in the process of migrating our backend from Oracle 11g to 19c. During testing I noticed that one of our DB calls has slowed down somewhat. On the older 11g schema, the call took around 2 seconds to run and return results, where as the new 19c schema the call takes between 10-15 seconds to finish running. It's a very simple select statement and running the same statement directly in TOAD takes under a second to return 7 records.
After further testing, I've concluded it only happens (or most notably) when model binding is used.
Code: Select all
_db.ExecuteQuery<MY_TABLENAME>("sql statement").ToList();
Specs:
c#
.NET 4.52
Devart.Data v5.0.1431.0 (runtime v2.0.50727)
Devart.Data.Linq v4.5.976.0 (runtime v2.0.5027)
Devart.Oracle v9.0.7.0 (runtime v2.0.5027)
Devart.Oracle.Linq v4.5.976.0 (runtime v2.0.5027)