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)