Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: MySQL Performance - Dimension Lookup/Update - Question

  1. #1
    Join Date
    Feb 2009
    Posts
    14

    Default MySQL Performance - Dimension Lookup/Update - Question

    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).

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    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.

  3. #3
    Join Date
    Feb 2009
    Posts
    14

    Default



    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.

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.