Re: ORDER BY RAND() taking too much time
Thanks for replying.
mysql>>DESCRIBE products;
+---------------------+---------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------------------+------+-----+---------------------+----------------+
| id | bigint(20) unsigned | | PRI | NULL | auto_increment |
| id_pr_data_feed | bigint(20) unsigned | | MUL | 0 | |
| product_code | varchar(255) | | MUL | | |
| product_title | varchar(255) | | MUL | | |
| product_description | text | | MUL | | |
+---------------------+---------------------+------+-----+---------------------+----------------+
and the products table is already indexed on "id_pr_data_feed" field.
Subject
Views
Written By
Posted
10198
April 29, 2006 05:30AM
3799
May 01, 2006 08:49AM
Re: ORDER BY RAND() taking too much time
4084
May 02, 2006 08:44AM
3535
May 02, 2006 02:24PM
3129
May 03, 2006 01:51AM
2923
May 03, 2006 02:11AM
3415
August 15, 2006 05:13PM
2596
May 11, 2006 04:25AM
3813
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.