Performance (RAM/CPU) with a lot of includes

Feb 12, 2016 at 12:37 PM
Hello, anybody using Effort with big linked tables?

We are currently using a statment to eager load a big amount of data (its not big per table but its linked a lot)

we have maybe 20-30 includes in the query.

in the tables there is not much more than 100-200 rows atm

Effort uses with this settinfs up to 2,5 GB (!) of memory and takes about 3 min to finish

The database enigine (localdb and oracle) deliver in < 3seconds

Am i doing something wrong or is effort just not optimized for such scenarios ?