sp_mda procedure

[Lance Andersen]

Francois Cetre wrote:
>
> We use ASE 11.5.1 with jConnect40.
> By using the Sybase monitor, I see that the procedure
> sybsystemprocs.sp_mda is called when we open a query calling a stored
> procedure.
>
> We use placeholders for the parameters :
> setSQL( "{?=call lookup_roamer( ?,?,?)}");
> where lookup_roamer is our stored procedure.
>
> What do the sp_mda procedure ?
> Must we set something when creating the query to reduce/avoid this
> overhead ?
>
> Our application make a lot of queries, and it seems that a lot of the
> time is spend in this sp_mda procedure.
>
> Any explanation will be usefull for us.
>
> François

What is happening from the jConnect side is that PowerJ is invoking
JDBC methods which require metadata from the backend. This is most
often
associated with the DatabaseMetaData class as well as a few methods from
Connection and ResultSetMetadata class.

I suspect this is occuring when processing the ResultSet returned from
your sproc.

lance
--
===============================================================================
Lance J. Andersen Email: lan...@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-6148
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================