Re: Why do quotes in an IN() clause effect performance so drastically?

Hi David, On Wed, Feb 18, 2009 at 4:25 AM, Daevid Vincent dae...@daevid.com wrote: I'm really confused. First, I don't understand why quoting my IN() values here caused them to run significantly slower than the non-quoted versions... on just this simple contrived example it can be as much as

Re: [OFFTOPIC] PHP and local-infile

Hi Mauricio, On Wed, Feb 18, 2009 at 12:58 AM, Mauricio Tellez mauricio.tel...@gmail.com wrote: Hi, sorry if this is an offtopic. I have a web site with LAMP, one module use a LOAD DATA LOCAL INFILE statement, all was running fine, but today I ran this module and I get an The used command is

Re: Why do quotes in an IN() clause effect performance so drastically?

Hi, I guess the id_file_set is an INT? The problem si most likely due to the fact you are comparing integer to string, which forces MySQL to use type conversion. For more information check http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html When type conversion occurs MySQL will not

Re: SPARC to x64 Transition

This is confirmed working on a small test set with MySQL 4.1.22 transitioning from SPARC to X64. Thanks everyone! -Aaron Here's the test set we used: CREATE TABLE `test_innodb` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `bigint` bigint(11) DEFAULT NULL, `float` float DEFAULT NULL,