i have a lot of mysql data (2 Lakhs data) how to collect data with in a seconds ? any idea

thanks in advance

If you run explain table_name in your mysql client and paste the output together with an example of data maybe we can give you a hand. And also paste the query.

put indexes on the columns that you use in the where clause

Member Avatar

diafol

In addition to the suggestions:

Using LIMIT clause may speed things up if you're after a specific number of records. Avoiding the '*' for return fields and naming the exact fields you want to return should also speed things up.
Using JOINS instead of subqueries where possible.

SELECT * FROM table_name WHERE start_date="$st_date" AND end_date="$en_date";

I hope you are having start_date and end_date fields in your Table....:)

Member Avatar

diafol

2 Lakhs

Are we talking 200,000 (or 2,00,000 in Asian num)? So you're saying that you have a long-ish table? Please post your query. We can't help properly if you don't provide this info.