Web service too slow when use SF Fill Method


Author
Message
hector
hector
StrataFrame User (144 reputation)StrataFrame User (144 reputation)StrataFrame User (144 reputation)StrataFrame User (144 reputation)StrataFrame User (144 reputation)StrataFrame User (144 reputation)StrataFrame User (144 reputation)StrataFrame User (144 reputation)StrataFrame User (144 reputation)
Group: StrataFrame Users
Posts: 52, Visits: 559
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
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search