Hello,
I've done a bit of testing and have determined that in my self-service collections (they only type I use), the overhead for populating the Entities is far beyond what I would expect it to be.
Ex:
I have a table with roughly 20,000 rows.
The query generated by LLBLGen Pro executes and returns data to the server in roughly 200ms.
If I borrow the SQL query generated by LLGen Pro and either populate a DataTable with that data or simply walk over a reader, fetching the values via GetValues, the overhead to process the data in minimal.
If I use the actual GetMulti call to fetch the data, getting the data (and more importantly, populating the entities) takes more than a full second longer than the manual query methods.
I did not see any other threads that mentioned this issue nor did I see any properties on the collection that would allow me to disable any unnecessary logic.
I can say that the table is tied to several other tables via the necessary keys but the query does not use any of that data (no prefetches have been added). I have also debugged the app to ensure that the only statement being executed is indeed the one generated by the GetMulti call.
Any thoughts/ideas?
