I would love to hear about it, since I really, really want them to be working properly.
me too!
do any of the dudes involved with mySQL read this forum ?
even though I didn't pay for support would they respond to a direct email ?
Brian Power.
From: Richard Tibbetts <[EMAIL PROTECTED]> To: Brian Power <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: anybody used prepared statements in 4.1 succesfully? Date: Thu, 22 Jan 2004 08:18:45 -0500
Since you aren't using the C API directly, you should make sure your API is actually using prepared statements. I don't know anything about Connector/J, but for example, last I checked, the Perl DBI mysql modules didn't really prepare statements when you called the prepare method. This is of course because they haven't been upgraded to use the new features yet.
Even if you did use the C API, I would be surprised if you get prepared statements working successfully. In my experience they have major bugs, at least in the current 4.1 alphas. Hopefully these bugs get fixed real soon now.
Of course, if other people don't find prepared statements to be buggy, I would love to hear about it, since I really, really want them to be working properly.
Hope this helps, Richard
On Thu, Jan 22, 2004 at 11:59:08AM +0000, Brian Power wrote:
> Has anybody used prepared statements in mySQL 4.1 succesfully. By
> succesfull I mean quicker !
>
> I have some prepared statement in my app and they take just as long the
> second++ time as they do hte first. My querys may need to be optimized (i
> just moved over from Access), but even so, shouldn't they be quicker the
> second time around.
>
>
> Im using java and Connector/J 3.0
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]