Hang while loading lgp file

Posts   
 
    
krikor
User
Posts: 2
Joined: 31-Mar-2006
# Posted on: 06-Apr-2006 02:15:24   

We have a large database with 1000+ objects. When I open the lgp, my pc goes into essentially a hang for 10+ minutes. The task manager doesn't show LLBL pegging the CPU, but most other applications on the pc become hung or uselessly slow while LLBL processes the lgp. Eventually, the load completes and then I can use LLBL normally. Fyi, this does not happen on a colleagues computer using the same lgp file. Any thoughts?

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 06-Apr-2006 08:33:41   

Please check the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=4002

If you have many un-used objects in your database catalog, then create another slim one then use the Designer to refresh the catalog pointing to the new location, this should make your lgp file smaller in size and loads faster.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 06-Apr-2006 10:38:59   

Also, if you don't use any stored procedures in your project, don't import them from the db when refreshing a catalog.

If you use a lot of stored procedures as well, create a separate project with just the procedures. They don't have any relation with the entities anyway, so you can safely create two projects from them.

Frans Bouma | Lead developer LLBLGen Pro