topic Re: Information Map taking too long to load into Enterprise Guide in SAS Enterprise Guide

Information Map taking too long to load into Enterprise Guide

SAPPER — Mon, 27 Dec 2010 18:04:45 GMT

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.

Re: Information Map taking too long to load into Enterprise Guide

Patrick — Tue, 28 Dec 2010 00:05:07 GMT

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.

Re: Information Map taking too long to load into Enterprise Guide

SAPPER — Tue, 28 Dec 2010 14:56:00 GMT

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.

Re: Information Map taking too long to load into Enterprise Guide

ChrisHemedinger — Tue, 28 Dec 2010 15:19:39 GMT

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

Re: Information Map taking too long to load into Enterprise Guide

SAPPER — Thu, 30 Dec 2010 16:23:10 GMT

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

Re: Information Map taking too long to load into Enterprise Guide

ChrisHemedinger — Tue, 04 Jan 2011 23:40:54 GMT

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

Re: Information Map taking too long to load into Enterprise Guide

Peter_C — Fri, 07 Jan 2011 18:18:03 GMT

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

Re: Information Map taking too long to load into Enterprise Guide

SAPPER — Sat, 08 Jan 2011 15:58:25 GMT

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.