1 Reply Latest reply on Jul 26, 2011 10:55 AM by philmodjunk

    Lots of records, slow database...suggestions

    ijontichy

      Title

      Lots of records, slow database...suggestions

      Post

      I'm bringing in a single line of machine generated metadata and then using calculations to parse the pieces of data i need out into separate fields.      But as this is time based data I have hundreds of thousands of records.

      What are the best settings to keep this moving as fast as possible?   Indexing the calculations or not?  

      I can work with it slow but would like to make it as speedy as possible.

      Thank you in advance!

      e.