When I try to create an edmx from my database it takes an extremely long time to complete. I have 900 tables in the database. I am adding 100 tables and views to my edmx. It has already been over 1 hour with out completing. Dbeng is running at 50% of cpu. The database is empty, just containing the table and view definition (when run againist a loaded database it never came back).
I am running version 22.214.171.12436.
When I tried adding just one table it took only a couple of seconds to complete.
Has anywone seen this behavhior?
The solution was to move the database local to the machine and upgrade to windows 7 64 bit with 4 more gig of memory. This took the process from 4 hours to 30 seconds. Even when I added all 900 tables and 700 views to my EDMX. This is of course a non answer as when the database was on a server it was Window 2008 R2 with 14 gig of memory to play in.
As you can see this is a work around but does not answer the question of why this is hanppening.
answered 14 Oct '11, 13:56