Re: Mysql speed :)

[Vivek Khera]

>>>>> "PD" == Paul DuBois <paul@stripped> writes:

PD> But why does it matter?  MySQL will convert the strings to numbers
PD> anyway.

But according to earlier threads here, it will mess up with BIGINTs

Also it may screw up with LIMIT:

$sth = $dbh->prepare("SELECT foo FROM bar LIMIT ?,?") or die;
$sth->execute($start,$howmany);

may fail depending on how you set $start and $howmany.  I got this
error the other day, where $start was the string "3" and DBI tried to
quote it, making my query look like this:

 ... LIMIT '3',2

and resulting in a parse error.  The fix was to call
$sth->execute($start+0,$howmany+0) and then DBI did the right thing.


-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       [phone]
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/