performance - Issue with EF 4.1 Pre-Compiled View Generation -
i have entity framework 4.1 dbcontext based model. using pocomodelgenerator.tt file generate entities. found querying 20,000 row sql table takes around 5 seconds code locally. takes less second when done directly in sql. in order boost performance, followed approach in link below generate pre-compiled views:
http://blogs.msdn.com/b/adonet/archive/2008/06/20/how-to-use-a-t4-template-for-view-generation.aspx
but performance didn't improve @ all. it's tad bit slower when running 2nd or 3rd time. here's project structure have:
here properties generated materialsmodel.views.cs file:
i have following questions:
- any idea can issue here?
- how check generated materialsmodel.views.cs being compiled output assembly.
- how check generated views indeed being used code?
- are properties setup correctly?
well answer 3rd simple: edit view class , comment call methods. run code, should through exception.
Comments
Post a Comment