Nigerians are the best scammers on the internet

God has bless Nigeria with one of the best thinking Idea but few of them use it wrongly .That does not mean that all Nigerians are the same and please change your mindset. I will like you to read this article i got from http://en.wikipedia.org/.

Scammers post profiles on dating websites to fish for victims. Upon finding victims scammers lure them to more private means of communication to allow for fraud to occur.

Some scammers use religious dating websites such as Christian sites, as the victims feel complacent, believing that the scammer has high moral values. [4][2]

Rhonda McGregor, an online moderator for the ROMANCE SCAMS Yahoo! group, stated that many romance scammers avoid answering personal questions and ask their victims many questions.

Narratives used to extract money from the victims of romantic scams include the following:

1. The scammer says that his or her boss paid the scammer in postal money orders. The scammer wants the mark to cash the scammer's money orders and then wire money to the scammer. The forged money orders leave the banks to incur debts against the victims.

2. The scammer says that he or she needs the mark to send money to pay for a passport. The scammer wants the mark to cash the scammer's money orders and then wire money to the scammer. The forged money orders leave the banks to incur debts against the victims.

3. The scammer says that he or she requires money for flights to the victim's country and somehow never comes, or says that he or she is being held against his or her will be immigration authorities, who demand bribes.

4. The scammer says that he or she is being held against her will for failure to pay a bill or requires money for hospital bills.

5. The scammer asks the victim to package goods sent from one address and send the goods to another address. The victim does not realize that the scammer set him or her as a part of a stolen goods distribution scheme. If police investigate the trail, the scammer's use of mules makes tracing of the scammer more difficult. In addition many businesses do not trust Nigerian addresses, so scammers use mules' United States addresses to give the businesses the impression that their transaction is domestic.

6. The scammer makes a proposal of marriage and needs the victim to send them the cash for the ticket. This is happening more out of the Ukraine now as the Federal Ahents begin to reel in Nigerian scammers.

How not to optimize a MySQL query

I just read a blog post discussing mysql query optimization and thought I’d put in my two cents.

The post suggests using a number of mysql specific statements (e.g. SQL_SMALL_RESULT, HIGH/LOW_PRIORITY, and INSERT DELAYED. STRAIGHT_JOIN was conspicuously missing). Unless absolutely necessary, this is usually A Bad Idea for at least two reasons. First, they are specific to MySQL which makes your database code less portable. This might or might not be a problem. Second, and perhaps more importantly, giving the SQL interpreter this sort of hint can lead to decreased performance in the future when your database or the interpreter changes. Telling the interpreter to anticipate a small result set (with SQL_SMALL_RESULT) might seem like a good idea, but could lead to problems when your table grows and the result becomes large! Basically, use these keywords with caution, and only when you really need them. And when you do use them, take special care in documenting where and why they’re in use.

The truth is there is no silver bullet that is going to make MySQL (or any dbms) run a poorly written query lightning fast. But here are some tips that the post somehow neglected to mention.

Properly index your tables

If you do a lot of lookups using a particular column of a table, or if you join on a column, that column should be indexed. Moreover, if all of the data that you are retrieving is available in the index (e.g. you’re using a multi-column index) then MySQL can avoid looking at the table altogether and execute your query using just the index.

Avoid superfluous queries

Don’t do this:

$result = query_db('select * from table1');

for each $result as $row
 $array[] = query_db('select * from table2 where column = '.$row['id']);
endforeach;

Do this:

$result = query_db('select table2.* from '
      .'table1, table2 where table1.id=table2.column');

Look for bottlenecks

Don’t waste time optimizing queries that aren’t bottlenecks in your application. Find the low hanging fruit and correct those problems first.

Learn SQL

This is the most important tip. SQL optimization really has to be done on a case by case basis, and you can’t do it unless you have a good understanding of the language and how you can use it to your advantage. You need to understand things like subqueries, grouping, left joins vs. right joins vs. full joins, etc. There is no free lunch.

If you’re interested in learning more, I highly recommend Stephane Faroult’s book The Art of SQL.