StrataFrame Forum
Back
Login
Login
Home
»
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
Post Reply
Like
1
Web service too slow when use SF Fill Method
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
hector
hector
posted 12 Years Ago
ANSWER
Topic Details
Share Topic
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
Reply
Like
1
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Web service too slow when use SF Fill Method
hector
-
12 Years Ago
Post Reply
Like
1
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search