Curious...I'm pretty amateur at DB optimization.

Many times I find myself writing.

ds = ds.exclude(id: ds1) if x
ds = ds.exclude(id: ds2) if z
ds = ds.exclude(id: ds2) if y

Is there any material performance impact from having multiple column loops 
of the same column in Postgres?

Should I be "UNION"ing the list of ids of first and then just do one 
exclude statement? My guess is it doesn't really matter ultimately because 
it's a direct loop on an indexed field even if it's called multiple times.
 
Aryk

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/a5b172f8-69c0-4775-826b-9d82f2594832o%40googlegroups.com.

Reply via email to