MySQL Performance - Dimension Lookup/Update - Question

[paulnus]

Before I get into any specific details regarding my transformation and setup, I was wondering what others are getting as far as throughput on an Dimension Update transformation or what one should expect with a 'proper' setup when using MySQL as a backend database?

I'm running into some very slow (40 RPS) transactions on a customer dimension I've been working on and have been pursuing around these forums/internet looking for possible solutions to something I obviously have setup incorrectly (transformation and/or server wise).

[MattCasters]

You should do better than that.
A few things to check are the existence of an index on the natural key(s) and the network speed/latency.

[paulnus]

:D

Good call. Im up to 800 RPS now that I have correctly indexed my table. I knew I was overlooking something sooooo simple. Wow. I feel dumb.

Thanks for the quick reply.

[MattCasters]

Take it easy, it's easy to miss in the heat of the battle.