PHP-MYSQL- fetching bulk data speed issue

See more:

MySQL

Hello Everybody,
I am facing a problem in MYSQL -fetching results.
I have two tables having more than 2 lacs rows/records in both tables.
In these two tables there is one column which is common.
Than please let me know how should I fetch records 100 by 100.

I have used the following ways:-
1) Left Join on common column
2) Indexing
3) LIMIT 0,100

By using these ways ,fetching query takes too much time(time in hours) and it is not acceptable.

I did not use stored procedures or any kind of triggers yet.

Need to ask what type of thinks i can use to decrease execution time. So please give me the solutions.

Thanks,