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