Web service too slow when use SF Fill Method

hector — Fri, 13 Jul 2012 11:53:50 GMT

Hi folks,

I have written in a web service in .NET

When i use SF Fill Method in a web service method it responds in 22 secs which is too slow.

But when i use direct ORACLE connection and query same table with exactly with same where conditions it responds less then a second.

Ok, i was expecting that using SF BO Fill Method to query a table may be little bit slower but it too much ! at least 22 times slower which is not acceptable.

Here is my code which use SF Method :
var loBO = new ACCOUNTSBO();

loBO.FillByPrimary(123);

And here is direct query method :

string sql = "SELECT * FROM ACCOUNTS WHERE ACCOUNTS.ACC_NO = 123 ";
                    OracleConnection con = new OracleConnection(GetAppConfig("MyDbConnectionString"));
                        con.Open();
                        OracleCommand cmd = new OracleCommand(sql, con);
                        OracleDataReader read=cmd.ExecuteReader();
                        if (read.Read())
                            read.Close();

Please advice

Kind regards

StrataFrame Forum » StrataFrame Application Framework - V1 » WebForms (How do I?) » Web service too slow when use SF Fill Method

Web service too slow when use SF Fill Method