ORDER BY RAND() taking too much time
Hi
In products table i am having around 15 laks of records, when i run following query it took around 10 to 12 sec....
The query is like:-
SELECT id, product_title, product_description, price_of_product, image_url FROM products WHERE products.id_pr_data_feed='some_id' ORDER BY id LIMIT 12;
Please help to to optimize this query...........
thanks
Subject
Views
Written By
Posted
ORDER BY RAND() taking too much time
10207
April 29, 2006 05:30AM
3802
May 01, 2006 08:49AM
4092
May 02, 2006 08:44AM
3539
May 02, 2006 02:24PM
3133
May 03, 2006 01:51AM
2931
May 03, 2006 02:11AM
3417
August 15, 2006 05:13PM
2600
May 11, 2006 04:25AM
3816
June 08, 2006 10:38AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.