-
Recent Posts
Archives
- November 2020
- January 2020
- July 2019
- March 2019
- November 2018
- October 2017
- July 2017
- March 2017
- February 2017
- August 2016
- April 2016
- February 2015
- January 2015
- October 2014
- February 2014
- January 2014
- November 2013
- September 2013
- July 2013
- March 2013
- February 2013
- January 2013
- December 2012
- October 2012
- September 2012
- August 2012
- July 2012
- May 2012
- April 2012
- March 2012
- January 2012
- December 2011
- October 2011
- September 2011
- July 2011
- February 2011
- January 2011
Categories
- Android (1)
- Cars (4)
- E-scooter (1)
- Linux (6)
- Debian (6)
- Virtualization (1)
- local news (2)
- MySQL (1)
- Optimization (1)
- Networking (1)
- Routers (1)
- no category (4)
- Optimization (1)
- Programming (9)
- Miscellaneous (2)
- php (6)
- Xdebug (2)
- Testing (1)
- BDD (1)
- Programs (1)
- Libre Office (1)
- Sport (25)
- Travelling (1)
- TV (1)
Meta
Category Archives: Optimization
… ORDER BY RAND()
Goal: get random record from database Lets sat we have table `lyric` ~ 33k records, `id` is primary key Simple: SELECT * FROM `lyric` ORDER BY RAND() LIMIT 1; 1 row in set (1.12 sec) wtf!? 1 second ? Note: … Continue reading
Posted in MySQL, Optimization, Optimization, php
Leave a comment