<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16544" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN
class=681075916-18032008>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=681075916-18032008></SPAN></FONT> </DIV>
<DIV><SPAN class=681075916-18032008><FONT face=Arial size=2>We are using MS SQL
Spatial FDO provider. </FONT></SPAN><SPAN class=681075916-18032008><FONT
face=Arial size=2>If we use more layers, the provider is too slow. It
takes about 3 second for each select command (mainly
c_KgMssDescribeSchemaCommand::Execute) and 2 seconds
after </FONT></SPAN><SPAN class=681075916-18032008><FONT
face=Arial><FONT size=2>FdoClassDefinition*
c_KgMssFeatureReader::GetClassDefinition()<SPAN class=681075916-18032008> is
calling.</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=681075916-18032008><FONT face=Arial><FONT size=2><SPAN
class=681075916-18032008>Do you have any idea how to improve the performance?
Thanks in advance for any help.</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=681075916-18032008><FONT face=Arial><FONT size=2><SPAN
class=681075916-18032008></SPAN></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=681075916-18032008><FONT face=Arial><FONT size=2><SPAN
class=681075916-18032008>Michal</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=681075916-18032008><FONT face=Arial><FONT size=2><SPAN
class=681075916-18032008></SPAN></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=681075916-18032008><FONT face=Arial><FONT size=2><SPAN
class=681075916-18032008></SPAN></FONT></FONT></SPAN><SPAN
class=681075916-18032008><FONT face=Arial><FONT size=2><SPAN
class=681075916-18032008></SPAN></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=681075916-18032008><FONT face=Arial><FONT size=2><SPAN
class=681075916-18032008></SPAN></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=681075916-18032008><FONT face=Arial><FONT size=2><SPAN
class=681075916-18032008></SPAN></FONT></FONT> </DIV></SPAN>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>