Information Map taking too long to load into Enterprise Guide

[SAPPER]

Hi All,

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?

Thanks
SAPPER.

[Patrick]

Is performance of the Information Map better when you use IMS?

Just a thought: May be the query you execute just doesn't perform too well.

[SAPPER]

HI Patrick,
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.
-Thanks
SAPPER.

[ChrisHemedinger]

EG uses the INFOMAPS engine to read the content of Information Maps. If you want to see which steps are taking the time, try running this report:

http://blogs.sas.com/sasdummy/index.php?/archives/177-Reporting-on-SAS-Information-Maps.html

Chris

[SAPPER]

Hi Chris,
Sorry for the late reply, we had a major upgrade on the sas server yesterday and it was down all day.

I ran the code and figured out the obvious which is there are close to 1500 dataitems in the information Map (thhis is one map against which the majority of the reporting is done).

My question now is how do I specify EG to skip checking the data items every time I open the Information Map in EG?
Is there any option/setting that i need to apply in the auto exe file?

Any inputs would be valuable.
-Thanks
SAPPER

[ChrisHemedinger]

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.

Chris

[Peter_C]

how about creating another info map with fewer columns?
is that not straightforward?

[SAPPER]

Hi Peter,
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.

Any suggestions to work around are welcome.

Thanks
SAPPER.