performance: round-trip/sql invocation cost
-------------------------------------------
Key: DNET-280
URL: http://tracker.firebirdsql.org/browse/DNET-280
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 2.5.1
Environment: windows
Reporter: Vasily Kabanov
Assignee: Jiri Cincura
I tried populating simple test table with parameterized insert statement. It
was very slow (~270 rows/second). Processor utilization was 60-70% in kernel
(which to me is a sign of something unproductive going on).
1st, I suspected query re-parsing to be a problem and packaged insert into a
SP, no luck.
2nd, suspected character sets convertions for strings and left only integer
parameters, again slow.
finally, suspected some marshaling or reflection issues and tried .NET over
ODBC.
Parameterized insert was slow again, but when using stored proc performance
went up: 6500 rows/second which is excellent.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
