Oracle EF driver with a Large Database
I've used LINQPad v5 for many years, with great success, to query an Oracle 11.2 database, using the IQ Driver in Direct Mode.
The database has over 4,000 tables, and nearly 8,000 views.
LINQPad's tree of Tables & Views populates in under a minutes, without undue stress to the PC running LINQPad.
Now our business system is upgrading to a new version, running on an Oracle 19.0 database.
I want to use LINQPad v6.14.10 (X64) and this guides me to use the EF driver, with the 'Oracle' provider.
I've installed the 'Latest release' version of '5.21.1' with EF Core Version '5.0.1'.
The new database has over 10,000 tables and over 13,000 views.
After setting up the connection, I get the 'Populating...' message for 12 minutes.
One CPU core is very active, and memory usage slowly rams up to over 8 GB.
Here's the 'Performance Graph' obtained using "Process Explorer":
This seems excessive to me.
Am I doing something wrong?
Is there any alternative driver that avoids this?