ygalipeau

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?

 

thanks

 

yannick

Outcomes