Thanks Tamas, Query itself is slow if i include all url strings. it takes about 10 mins. But when i hit one at a time, i see better response overall. Yes so was planning on running them in parallel.
We only have read permissions and hence i am not allowed to add new index, but good idea, will try reaching out to Admin and see if they can add this. i have not tried that way of similar to, will try that as well. On Tuesday, 26 February 2019 00:36:26 UTC+5:30, Tamás Gulácsi wrote: > > How fast is the query? You can make it parallel, but if it is sliw, the > you have to target that first. > > How big is the set of one user's all urls? How fast is to get this? Maybe > adding some indexes may help > > > How fast is the query with one pattern only? Maybe combining them into a > "similar to '%(abc|def|ghi)%'" would be faster? > > -- You received this message because you are subscribed to the Google Groups "golang-nuts" group. To unsubscribe from this group and stop receiving emails from it, send an email to golang-nuts+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
