another questions regarding the AF oledb use as a SQL Linked server.
i have this simple query
select * from ekhoaf.ekho.asset.element
where my ekhoaf is a linked server to the Ekho AF DB. first time it take 7-10 seconds to retreive 5 elements (i understand the connection requirement the first time). but then it always take 5-7 seconds to retreive the same elements. if i wait let's say 1 minutes and reexecute it, it goes for another 7-10 seconds. did anybody experience the same thing?