Warning: mysql_query(): Your query requires a full tablescan (table Mobile_Tunes, 4 rows affected). Use EXPLAIN to optimize your query. in D:\Program Files\Apache Group\Apache2\htdocs\Breez\mtunes_main.php on line 47
Warning: mysql_query(): Your query requires a full tablescan (table Mobile_Tunes, 4 rows affected). Use EXPLAIN to optimize your query. in D:\Program Files\Apache Group\Apache2\htdocs\Breez\mtunes_main.php on line 70
************************************************************
this table will be populated with at least 60,000 records. these 4 records are just for testing purpose.
so if you can tell me what to do to avoid this warning, then it will be great help for me.
If you're selecting all rows from the table (bad idea for 60,000 rows), then you won't be able to avoid it.
If you want to select a portion of the rows, create an index on the relevant fields.
--
Postgresql & php tutorials
http://www.designmagick.com/