Home › Forum › Software › db-performance

Log In Register Lost Password
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • February 9, 2015 at 12:19 am #1306
    Radu
    Keymaster

    Thanks Vinz, I’ll add it to the prod server too since select by id is often used.

    Would be very helpful if Ally or the other guys with expertise in DBs would step in for some more hints/comments.

    February 9, 2015 at 8:38 pm #1315
    vinz
    Member

    Improve of this new index is significant!
    It should also improve your creation of the current charts.

    But don’t use too much indices, cause they will lower your insert-perfomance.
    … but at the moment (you have a maximum of 160 inserts per minute) this will not have influence. 🙂

    February 11, 2015 at 10:13 am #1328
    Radu
    Keymaster
     Your SQL query has been executed successfully (Query took 196.2649 sec)
CREATE INDEX idx_db_devid ON uradmonitor(
db_devid
)

    I was just creating 7 charts in parallel for some experiment with various tubes. It was hard for the server, but after adding this additional index all 7 were generated instantly!

    Speed improvement: amazing!

    Thanks

  • Author
    Posts
Log In Register Lost Password
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.