O'Reilly logo

Mastering SQL Server 2014 Data Mining by Debarchan Sarkar, Amarpreet Singh Bassan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Troubleshooting the data mining structure performance

There can be many reasons why this might happen; in our case, if we make all the columns as input and try to generate the data mining structure, it will definitely take a long time because there will be a large number of trees or clusters to be generated depending on the algorithm that we are using. We will discuss a few of the commonly used algorithms and the parameters that can be altered to improve the processing performance.

The Decision Tree algorithm

The information that is required to classify data will proportionately increase with the increase in the input values. Therefore, there is a need to optimize the performance. The performance can be optimized by the following aspects:

  • Reducing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required