BLOG
Fetch a random row from the database without using triggers, and quickly.
It's a pretty classic SQL problem, and one that many blogs attempt to tackle – and do a poor job. Most people are quick to recognize that ORDER BY RAND() is a bad idea. So then they think that using MIN(id) / MAX(id) you can find a random index. Also bad! Let's see what can be done.
Posted in: Database Administration, Programming 2 comments
Got a comment? Want a quote?
Email or call 303.952.7490
Search Blog
Archive
Categories
Credit Union Marketing (1)
Database Administration (3)
Denver Advertising (7)
Denver Internet Marketing (24)
Denver SEO (50)
Denver Web Design (13)
Denver Web Development (21)
Information Architecture (4)
Integrated Interactive (7)
Lead Generation (5)
Non-Profit Marketing (3)
Programming (15)
SEO Advice (43)
Social Media Marketing (13)
Usability (11)
Web Design (4)
Tags
Ad Extensions AdWords awards B2B Internet Marketing Binary Blogging careers database denver advertising agency Denver Interactive Agencies Denver Interactive Agency Denver Internet Marketing Denver Internet Marketing advice denver ppc denver ppc advertising denver programming jobs Denver search engine marketing Denver Search Engine Optimization Denver SEO denver seo agency Denver SEO intern Denver social media marketing Denver Software Development Denver Usability Denver web design Denver Web Development Denver website design Fusionbox Fusionbox Framework google grants Google rankings HTML pages information architecture Internet Marketing JavaScript jobs keyword research link building linkbuilding mobile web applications Non Profit Marketing online reputation management Pay per Click PDF pages PHP development post launch checklist PPC pre launch checklist Programming Project Management pubcon Python jobs Ruby jobs search engine optimization SEO SEO advice seo-friendly urls social media advice Social Media Marketing Social Media Marketing for Credit Unions SQL stock photos TextMate Top B2B Interactive Agencies web design Web Development web development jobs WORM
