Hi,
I have changed my query but it is sooooooooo slow :( Please, help me!
Thank u very much!
Edilson.
-------------------------------------------------------------
Query ->
SELECT a.idemail, a.fklastresp
FROM wmkt_email a, wmkt_client b, wmkt_maillist_client c
LEFT JOIN wmkt_email_sent d ON a.idemail=d.fkemail
WHERE d.fkemail IS NULL
AND c.bActive AND c.fkmaillist IN (2)
AND a.idemail=b.fkemail AND c.fkclient=b.idclient
ORDER BY fklastresp LIMIT 1000
-------------------------------------------------------------
>Tables structures ->
>--------------------------------------------------------
>Table,Create Table
>wmkt_email,CREATE TABLE `wmkt_email` (
> `idemail` int(11) NOT NULL auto_increment,
> `email` varchar(255) NOT NULL default '',
> `fklastresp` int(11) NOT NULL default '0',
> PRIMARY KEY (`idemail`),
> UNIQUE KEY `ixEmail` (`email`)
>) TYPE=MyISAM
>
>--------------------------------------------------------
>Table,Create Table
>wmkt_client,CREATE TABLE `wmkt_client` (
> `idclient` int(11) NOT NULL auto_increment,
> `realname` varchar(80) NOT NULL default '',
> `fkemail` int(11) NOT NULL default '0',
> `dtInsert` datetime default NULL,
> `dtLastUp` datetime default NULL,
> `fkuser` int(11) NOT NULL default '1',
> PRIMARY KEY (`idclient`),
> KEY `ixFkemail` (`fkemail`)
>) TYPE=MyISAM
>
>---------------------------------------------------------
>Table,Create Table
>wmkt_maillist_client,CREATE TABLE `wmkt_maillist_client` (
> `fkmaillist` int(11) NOT NULL default '0',
> `fkclient` int(11) NOT NULL default '0',
> `dtInsert` datetime default NULL,
> `bActive` tinyint(4) NOT NULL default '1',
> KEY `ixEmailList` (`fkmaillist`,`fkclient`)
>) TYPE=MyISAM
>
>---------------------------------------------------------
>Table,Create Table
>wmkt_email_sent,CREATE TABLE `wmkt_email_sent` (
> `idemailsent` int(11) NOT NULL auto_increment,
> `fkpbl` int(11) NOT NULL default '0',
> `fkemail` int(11) NOT NULL default '0',
> `dtSend` datetime default NULL,
> `nResult` int(11) NOT NULL default '0',
> `dtLastUp` datetime default NULL,
> `nMachine` int(11) NOT NULL default '0',
> PRIMARY KEY (`idemailsent`),
> UNIQUE KEY `ixUEmailPbl` (`fkemail`,`fkpbl`),
> KEY `ixnMacPbl` (`nMachine`,`fkpbl`,`fkemail`)
>) TYPE=MyISAM
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
