I just ran into an issue where I thought a query that was being dynamically
built was hanging. After checking the DB for the query, i don't see any of
the where clauses in the one that was hung. What I saw was:
`SELECT * FROM table_name LIMIT 1`
So then I saw this conditional that had me wonderin
On Tue, Oct 12, 2021 at 2:40 PM cincy_kal
wrote:
> I just ran into an issue where I thought a query that was being
> dynamically built was hanging. After checking the DB for the query, i don't
> see any of the where clauses in the one that was hung. What I saw was:
> `SELECT * FROM table_name LIM
into such
issues and do in fact use the same trick.
From: sequel-talk@googlegroups.com on behalf of
Jeremy Evans
Sent: Tuesday, October 12, 2021 8:33 PM
To: sequel-talk@googlegroups.com
Subject: Re: dataset columns method performance
On Tue, Oct 12, 2021
On Wed, Oct 13, 2021 at 2:03 PM Josh Crank
wrote:
> Our DBA mentioned that he uses LIMIT 0 himself.
> But from what I gather in regards to the ORDER BY RANDOM(), its because
> when you don't have column that has small gaps between values (such as our
> pk UID's), then attaching an order by with a