Re: BIG Istar performance problem

Thanks jack for your fast responce, >> >> Subject: BIG Istar performance problem. >> ---------------------------------------- >> > >How are you using the istar? Are you: > >database a > >SELECT * FROM b@engine:table> >? > >If so - we've discovered that using a DATABASE statement to point at the >second engine is more efficient. Yes, that is correct. The most time is used to open a database and when that is done things works fast. A lot of applications will select from 2 or more Onlines by using synonyms. A lot of applications are build up of many executeable programs, which after load will run an open database statement. Both are a problem - a big one when this part performs very slow. thanks Jack ----------------------------------------------------------------- Databaseadministrator Poul Pedersen Kuwait Petroleum (Danmark) A/S Hummeltoftevej 49 Mail: pp@q8.dk 2830 Virum Voice: +45 45 98 45 94 Denmark Fax: +45 42 85 14 18 -----------------------------------------------------------------