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