Re: anybody used prepared statements in 4.1 succesfully?

2004-01-23 Thread Brian Power
KEY `H_Age` (`H_Age`), KEY `TrainerID` (`TrainerID`), KEY `H_ID` (`H_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 From: Mark Matthews <[EMAIL PROTECTED]> To: Brian Power <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: anybody used prepa

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-23 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brian Power wrote: > yeah, I tried the new connector. but I'm getting strange results when > using a date field, > > > My sql looks like.. > > Where R_Date < ? and R_Date > ? and H_ID <> ? > > My code looks like... > > perparedStmt.setDate(1,n

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-23 Thread Brian Power
L PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: anybody used prepared statements in 4.1 succesfully? Date: Thu, 22 Jan 2004 09:49:35 -0600 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brian Power wrote: > anybody used prepared statements in 4.1 succesfully? > > > Has anybody used

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-22 Thread Brian Power
CTED] Subject: Re: anybody used prepared statements in 4.1 succesfully? Date: Thu, 22 Jan 2004 09:49:35 -0600 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brian Power wrote: > anybody used prepared statements in 4.1 succesfully? > > > Has anybody used prepared statements in mySQL 4.1 s

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-22 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brian Power wrote: > anybody used prepared statements in 4.1 succesfully? > > > Has anybody used prepared statements in mySQL 4.1 succesfully. By > succesfull I mean quicker ! > > I have some prepared statement in my app and t

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-22 Thread Richard Tibbetts
On Thu, Jan 22, 2004 at 01:51:09PM +, Brian Power wrote: > 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 ? My experience is that if you aren't filing rock-solid bug reports, and you aren't paying, the de

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-22 Thread Richard Tibbetts
If you have the right level of logging turned on, you will see evidence in your query log. Generally you see command sequences like Connect, Query, Query, Query, Quit. With prepared statements you would see Connect, Prepare, Execute, Execute, Execute, Quit. I don't know off hand if there is a go

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-22 Thread Brian Power
r 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

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-22 Thread Sid Lane
| | To: Brian Power <[EMAIL PROTECTED]> | | cc: [EMAIL PROTECTED] | | Subject: Re: anybody

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-22 Thread Richard Tibbetts
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 cours

anybody used prepared statements in 4.1 succesfully?

2004-01-22 Thread Brian Power
anybody used prepared statements in 4.1 succesfully? 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