Hello Joseph,
Tuesday, October 14, 2008, 2:07:01 PM, you wrote:
> First of all you will want to index your database. I am guessing the
> query is taking forever due to it not having indexes.
> Also I would suggest that you do this
> $res = ("SELECT * FROM table WHERE email = ' ". email2chk." ' ";
> also I would make sure you have no duplicates in the database by
> setting a UNIQUE on the email column.
> Doing these things should speed up the site however note that if you
> check this on every page load it will be resource intensive.
> also what is $email2Chk is it a string or your array of emails?
> Thanks,
> Joseph Crawford
> On Oct 14, 2008, at 1:57 AM, [EMAIL PROTECTED] wrote:
>> Hello NYPHP,
>>
>> I have an array that has 13000 email addresses. For now, its in the
>> script but will be in a database table eventually. It is a list of
>> known bad guys.
>>
>> I have a database table with 9000 records and one of the fields is
>> an email address.
>>
>> In PHP I am using a foreach to loop through the array and do a
>> database lookup to try to find any matching emails.
>>
>> I am using this query inside the foreach loop:
>>
>> $res = ("SELECT * FROM `table` WHERE `email` = '$email2Chk'");
>> $numRows = mysql_num_rows($res);
>> if ( !empty($numRows ))
>>
>>
>> It processes about 12000 addresses in the array and the script
>> times out.
>>
>> Anyone have a better idea for doing this task?
>>
>> TIA for any help.
>>
>> --
>> Best regards,
>> mikesz mailto:[EMAIL PROTECTED]
>>
>> _______________________________________________
>> New York PHP Community Talk Mailing List
>> http://lists.nyphp.org/mailman/listinfo/talk
>>
>> NYPHPCon 2006 Presentations Online
>> http://www.nyphpcon.com
>>
>> Show Your Participation in New York PHP
>> http://www.nyphp.org/show_participation.php
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
> __________ Information from ESET Smart Security, version of virus
> signature database 3519 (20081013) __________
> The message was checked by ESET Smart Security.
> http://www.eset.com
$email2Chk is an array element. I thought it was but email is not
indexed. Weird, they index a lot of stuff that doesn't matter but
email is missing....
--
Best regards,
mikesz mailto:[EMAIL PROTECTED]
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
