When I try to open an information Map in Enterprise Guide, it is taking over a minute to load.(Network speed is quite fast and also the PC's are brand new pc's with quad core processors @ 2.66 Ghz and 4GB RAM) .
I see that EG goes through a lot of steps like "Assighning libanames",
"Discovering Information Map member name","Gathering Information Map data/filter/prompts" etc.
Is there a way to speed up the process of loading the information Map or any Best Practices that I can implement to fasten the process?
The information map takes approx 5 minutes to load in IMS.
I am not executing anything at this point in EG.
The problem is loading the Information Map into EG to start building the query.
There's no way to tell EG to skip checking the data items.
You can use the INFOMAPS libname engine directly, if you want to write programs that pull data out of the maps. But you won't be able to skip the "reading of the metadata" when you use the EG "Open Information Maps" window.
The Map is based on Joins between two databases and has close to 1500-2000 Data items .
The intention is to use the newly developed database which has all the logic and calculations that the business needs already calculated and populated in the database tables.
So we are trying to use as many calculated fields from this new database and for the one ODD field that is not in the newly created database we have to extract the data from the Old database.
The new database was created with fields (calculations) that are used more than thrice in the reports. But for fields that are used only once/ twice in any report , we have to go back to the old database and gather it from there.