[Mysql 4.1.22][PHP 5.2.5] upgrade a php5 mysql4 query lenta

[pyotrex]

CREATE TABLE `dyn_catalogo` (
  `id` int(7) unsigned NOT NULL auto_increment,
  `id_produttore` int(5) unsigned NOT NULL default '0',
  `id_padre` int(6) unsigned NOT NULL default '0',
  `id_file` int(7) unsigned default NULL,
  `numero` varchar(50) default NULL,
  `codice` varchar(50) default NULL,
  `ean` varchar(50) default NULL,
  `qta` int(6) unsigned default NULL,
  `evidenza` int(1) unsigned NOT NULL default '0',
  `offerta` int(1) unsigned NOT NULL default '0',
  `novita` int(1) unsigned NOT NULL default '0',
  `classe` char(2) NOT NULL default '',
  `sort_c` int(7) unsigned default NULL,
  `sort_p` int(7) unsigned default NULL,
  `selettore` int(1) unsigned NOT NULL default '0',
  `confezioni` int(4) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11593 ; 

475 record