Re: mysql_stmt_fetch()
Posted by: Nulik Nol
Date: August 17, 2011 08:50PM

I found the problem with my code. I have declared the parameter id_company of long long in bind_param function, but was passing only long. I found this when I activated query loging with --log parameter to mysqld. It is a mystery why it works for the first time though.
To answer my second question, yes you can set up bind and result params after prepare and then call many times execute and fetch, so I believe i will gain a lot of performance this way since I will have all prepared queries in a daemon and it will serve them to a fastcgi program spawn from webserver.

Options: ReplyQuote

Written By
August 15, 2011 02:49PM
Re: mysql_stmt_fetch()
August 17, 2011 08:50PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.