Stored Procedure Calling function

Stored Procedure Calling function

Postby 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
irimawi
 
Posts: 2
Joined: Sat 17 May 2008 18:16

Postby 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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for MySQL