AF Oledb Provider performance

Discussion created by ygalipeau on Jan 11, 2011
Latest reply on Jan 13, 2011 by aabrodsky

good morning,


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?