MySQL Forums :: C#, Mono, .Net :: Stored Procedure Cache Problems

Hey Everyone! I looked at all the posts from this whole forum for C# and .NET and I couldn't find any answers, so here goes.

When I call stored procedures, they always seem to be pulling from the server everytime, and do not cache at all. I have not turned off caching in connection string or done anything special to turn on/off any feature of the connection.

Here is an example:

WebDev.WebServer.EXE Information: 0 : Retrieving procedure metadata for `gdkb`.`get_articletype_by_id` from server.
WebDev.WebServer.EXE Information: 0 : Retrieving procedure metadata for `gdkb`.`get_regionalscope_by_id` from server.
WebDev.WebServer.EXE Information: 0 : Retrieving procedure metadata for `gdkb`.`get_product_by_id` from server.
WebDev.WebServer.EXE Information: 0 : Retrieving procedure metadata for `gdkb`.`get_productversion_by_id` from server.
WebDev.WebServer.EXE Information: 0 : Retrieving procedure metadata for `gdkb`.`get_product_by_id` from server.
WebDev.WebServer.EXE Information: 0 : Retrieving procedure metadata for `gdkb`.`get_supportgroup_by_id` from server.
WebDev.WebServer.EXE Information: 0 : Retrieving procedure metadata for `gdkb`.`get_supportmember_by_id` from server.

And this is only a small snapshot from the whole. This set is repeated 25 times or more depending on results on page. Basically, if "get_product_by_id" is downloaded from server and cached, wouldn't that mean that if it gets called again, it should load from cache and not transfer from server?

Am I confused about what the Stored Procedure cache is supposed to do?

Is there a way to create a stored procedure command object FORCING to read from cache? Am I missing something here?

Any help would be appreciated. The entire thing works, but its quite slow if a large result set is attempting to be displayed in the ASP.NET site pages.

Thanks,

Philippe