Lots of records, slow database...suggestions
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!