Re: Slow query

[Mike van Hoof]

Hello, I pinned down the problem to the order by line. If i leave this 
away the query is done in 0.05 seconds.

- Mike
Mike van Hoof schreef:
Hello,

i have the following query:

   SELECT DISTINCT (
   Waarde
   ) AS bestemming
   FROM xml_kenmerk
   WHERE Omschrijving = 'Bestemming'
   AND IF (
   DatumBegin IS NOT NULL

   AND DatumBegin != '0000-00-00', DatumBegin <= CURDATE( ) , 1 =1
   )
   AND IF (
   DatumEind IS NOT NULL

   AND DatumEind != '0000-00-00', DatumEind >= CURDATE( ) , 1 =1
   )
   ORDER BY Waarde


Table structure:

   CREATE TABLE `xml_kenmerk` (
     `KenmerkRolid` int(11) NOT NULL auto_increment,
     `Omschrijving` varchar(255) default NULL,
     `Waarde` varchar(255) default NULL,
     `DatumBegin` date default NULL,
     `DatumEind` date default NULL,
     `OrganisatieRolid` int(11) unsigned default NULL,
     `RelatieRolid` int(11) unsigned default NULL,
     PRIMARY KEY  (`KenmerkRolid`),
     KEY `OrganisatieRolid` (`OrganisatieRolid`),
     KEY `RelatieRolid` (`RelatieRolid`),
     KEY `Omschrijving` (`Omschrijving`),
     KEY `Waarde` (`Waarde`),
     KEY `DatumBegin` (`DatumBegin`),
     KEY `DatumEind` (`DatumEind`)
   ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2163460 ;


and it contains approx. 7500 rows. But the query takes 1.5 seconds. 
Does anybody know how i can get bether preformance from this query?

- Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]