<!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.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>I am trying to
figure out how Batch Insert should work. From reading documentation and
looking in implementation in providers, it is very unclear how it should be
used.</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>Looking at shp,sdf
and my sql, I see only shp provider is implementing it.</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>Documentation say
batch parameters is collection of parameter values for each
row.</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>I see from shp file
that it is matching batch parameter value to property values collection (
GetPropertValues )<FONT face="Times New Roman" size=3><FONT face=Arial size=2>
using parameter name.</FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>I see from shp
implementation that property values are supposed to be of type FdoParameterValue
( I think that needs to be added to documentation).</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>SHP provider is
implementing it in such way that it is matching this parameters to properties
for every row, and then converting to properties value for each row.
Altogether is very inefficient.</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>it also means that
for every row we need to send parameter name + value.</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>I think that batch
insert should be implemented in such way that batch parameters values are send
as collection of values and parameter names are sent just as one row of
parameter names.</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>In batch inserts,
number of parameters or their order won't changed. This would be minimum
optimization could go further.</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=406182811-28102006>Another thing
I saw in shp implementation is that it is accepting just FdoParameter as type
for property value (throw exception for other),</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=406182811-28102006>which would
mean that it won't accept constant values in batch insert ( I am ok with that,
but also should be documented ). </SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=406182811-28102006>If this is
true for general way of FDO batch insert implementation than batch inserts can
be even more optimized.</SPAN></FONT></FONT></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>Try to
summarize:</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>I think we need to
define what are rules for batch inserts and according to that optimize batch
inserts.</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial size=2>Batch inserts could
become very important if FDO gets wider acceptance.</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2>Haris</FONT></SPAN></DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406182811-28102006><FONT face=Arial
size=2></FONT></SPAN> </DIV></BODY></HTML>