Hi,
I'm using mysql with php and have recently made some effort optimizing all queries on a project and I noticed something strange and wanted to check if this is correct.
Lets say I have a table looking like this: CREATE TABLE `profile_visitors` ( `profile_owner` int(10) unsigned NOT NULL default '0', `profile_visitor` int(10) unsigned NOT NULL default '0', `timestamp` int(10) unsigned NOT NULL default '0', KEY `profile_owner` (`profile_owner`) ) TYPE=MyISAM;
Is there or rather, should it be any speed difference between the 2 queries below:
SELECT * FROM profile_visitors WHERE profile_owner="3432";
and
SELECT * FROM profile_visitors WHERE profile_owner=3432;
Would be nice to know the expected behaviour.. :) Currently running 3.23.56
Best regards,
Eric-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
