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.
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();
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.


.NET Framework
Version 2.0 or later

See Also


MimerMonitorInstance Class
MimerMonitorInstance Members