Stored Procedure Calling function

irimawi · Post by **irimawi** » Sat 17 May 2008 18:46

I am running MYSQL 5.x with .NET 3.5 framework that calls a stored procedure that returns some results, the stored procedure calls Mysql function. Running the query on query browser takes about 2 seconds, however, when running that through .net with corelab, the same query takes 15+ seconds, the function we have matches 2 strings to each other, no selects involved in it, please advise.

Thank you,
Ihab

Alexey.mdr · Post by **Alexey.mdr** » Mon 19 May 2008 08:50

Please send me (alexeyman*crlab*com) a small test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include the
definition of your own database objects.
Please do not use third party components.
If it is impossible for you to create the test project, send us a piece of
your code where the problem occurs.