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 ?