Hi!
[DELETED]
slow multi-join query for small database (~120K t
Moderator: NorbertKrupa
Re: slow multi-join query for small database (~120K t
Last edited by id10t on Fri May 08, 2015 4:46 pm, edited 1 time in total.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: slow multi-join query for small database (~120K t
I'm providing the link to your StackOverflow question to avoid cross-posting and show what others have suggested.
I threw your profile results into Excel and sorted on the counter_value column. The costliest operations are (not surprisingly) the JOIN's. At this point, I would suggest that you explore Pre-join Projections and Join Predicates if you plan on using your query. Like I mentioned on your StackOverflow question, you may want to consider de-normalizing your schema (if possible).
I threw your profile results into Excel and sorted on the counter_value column. The costliest operations are (not surprisingly) the JOIN's. At this point, I would suggest that you explore Pre-join Projections and Join Predicates if you plan on using your query. Like I mentioned on your StackOverflow question, you may want to consider de-normalizing your schema (if possible).
Checkout vertica.tips for more Vertica resources.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: slow multi-join query for small database (~120K t
I've found that community.vertica.com is the least helpful. I've had several open questions on there for quite some time with no activity. StackOverflow and these forums seem to be the best resources IMO.Much appreciated. I don't yet know how much the communities overlap (SO, here, and http://community.vertica.com/ ) so I'm learning.
Checkout vertica.tips for more Vertica resources.
Re: slow multi-join query for small database (~120K t
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Fri May 08, 2015 4:46 pm, edited 1 time in total.
Re: slow multi-join query for small database (~120K t
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Fri May 08, 2015 4:40 pm, edited 1 time in total.
Re: slow multi-join query for small database (~120K t
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Fri May 08, 2015 4:40 pm, edited 1 time in total.