"HankD" <MrHankD@gmail.com> wrote in message
news:1115234086.081372.5030@o13g2000cwo.googlegroups.com...
> I have a simple remoting setup that returns a dataset. I decided to try
> to improve my performance by using the DatasetSurrogate class from
> http://support.microsoft.com/default.aspx?scid=kb;en-us;829740 The
> results was the time to retrieve 11,000 rows nearly tripled. I am
> assuming I have done something wrong. The code still works but the
> performance is awful. I am wondering if it is because I am using
> Inherits MarshalByRefObject. Thanks a lot for any help.
>
> Here is my setup.
>
> My remoting object is hosted in IIS so I am using the HTTP channel with
> the BINARY formatter.
>
> My client code is something like this-
> ***********************************************************
>
> Private afwlookupBOL As Ifire_bol.Ifw_lookup_BOL =
> CType(remoting_BOL.GetObject(GetType(Ifire_bol.Ifw_lookup_BOL)),
> Ifire_bol.Ifw_lookup_BOL) <--Uses Ingo Rammer's Helper Class
>
> Dim dss As DataSetSurrogate.DataSetSurrogate
> dss = afwlookupBOL.GetResults(aSelectStatement)
> dsResults = dss.ConvertToDataSet()
>
> My remoted object is something like this-
> ************************************************************
> Public Class fw_lookup_BOL
> Inherits MarshalByRefObject
> Implements Ifire_bol.Ifw_lookup_BOL
>
> Public Function GetResults(ByVal strSQL As String) As
> DataSetSurrogate.DataSetSurrogate Implements
> Ifire_bol.Ifw_lookup_BOL.GetResults
>
> Dim aOLEDAL As New fire_dal.OleDAL
> Dim ds As DataSet
> ds = aOLEDAL.dsOLE(strSQL, fire_con.constants.cnTypes.FMINWEB)
> Dim dss As DataSetSurrogate.DataSetSurrogate
> dss = New DataSetSurrogate.DataSetSurrogate(ds)
> GetResults = dss
> ' Return
> End Function
>

"HankD" <MrHankD@gmail.com> wrote in message
news:1115234086.081372.5030@o13g2000cwo.googlegroups.com...
>I have a simple remoting setup that returns a dataset. I decided to try
> to improve my performance by using the DatasetSurrogate class from
> http://support.microsoft.com/default.aspx?scid=kb;en-us;829740 The
> results was the time to retrieve 11,000 rows nearly tripled. I am
> assuming I have done something wrong. The code still works but the
> performance is awful. I am wondering if it is because I am using
> Inherits MarshalByRefObject. Thanks a lot for any help.
>
> Here is my setup.
>
> My remoting object is hosted in IIS so I am using the HTTP channel with
> the BINARY formatter.
>
> My client code is something like this-
> ***********************************************************
>
> Private afwlookupBOL As Ifire_bol.Ifw_lookup_BOL =
> CType(remoting_BOL.GetObject(GetType(Ifire_bol.Ifw_lookup_BOL)),
> Ifire_bol.Ifw_lookup_BOL) <--Uses Ingo Rammer's Helper Class
>
> Dim dss As DataSetSurrogate.DataSetSurrogate
> dss = afwlookupBOL.GetResults(aSelectStatement)
> dsResults = dss.ConvertToDataSet()
>
> My remoted object is something like this-
> ************************************************************
> Public Class fw_lookup_BOL
> Inherits MarshalByRefObject
> Implements Ifire_bol.Ifw_lookup_BOL
>
> Public Function GetResults(ByVal strSQL As String) As
> DataSetSurrogate.DataSetSurrogate Implements
> Ifire_bol.Ifw_lookup_BOL.GetResults
>
> Dim aOLEDAL As New fire_dal.OleDAL
> Dim ds As DataSet
> ds = aOLEDAL.dsOLE(strSQL, fire_con.constants.cnTypes.FMINWEB)
> Dim dss As DataSetSurrogate.DataSetSurrogate
> dss = New DataSetSurrogate.DataSetSurrogate(ds)
> GetResults = dss
> ' Return
> End Function
>