[LRUG] Speeding up a SQL query

[Karl Freeman]

Alongside some great suggestions already one thing I would consider (which
you may off, already) is. Is this sluggishness acceptable for those times
it gets called? (ie could the stakeholder accept this call to 'take a
while') Could these be put elsewhere?.

Karl.


On 21 February 2014 11:30, Tom Stuart <tom at codon.com> wrote:

> On 21 Feb 2014, at 11:22, Andrew Stewart wrote:
> > Does anyone have any tips?
>
> Have you considered precomputing some kind of hash (of the attributes
> whose values you care about) when you create/update the record, and then
> indexing & querying on that? Even if there are collisions, it's probably
> easy to filter them out in Ruby after the query.
>
> Cheers,
> -Tom
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20140221/4370d89e/attachment-0003.html>