Mimer SQL Data Provider
PrepareCount Property




Mimer.Data.Client Namespace > MimerMonitorInstance Class : PrepareCount Property
The number of times an application has passed this statement to the server to compile it.
Syntax
'Declaration
 

Public ReadOnly Property PrepareCount As Integer
public int PrepareCount {get;}
public read-only property PrepareCount: Integer; 
public function get PrepareCount : int
public: __property int get_PrepareCount();
Remarks
Only the first call actually compiles the statement. However, if it is the same application that is responsible for the compilations unnecessary communications may be used. The application should consider caching the SQL statement by reusing the statement (use single Prepare and many Execute; the actual name of the calls used depends on the database interface used).

It is also possible to compare PrepareCount with ExecuteCount to determine if applications are well written. In this case there are more ExecuteCount than PrepareCount.

Requirements

.NET Framework
Version 2.0 or later

See Also

Reference

MimerMonitorInstance Class
MimerMonitorInstance Members

Send Feedback