LM2903: Is it a good idea to keep large resistors in feedback path of a comparator circuit?

Dear Team,

I was seeing a comparator circuit designed with LM2903. The circuit diagram is given below. It is working as expected in simulation.

In the feedback path you can see a 1 MΩ resistor.

My questions are:

1. Is it a good idea to put large resistors in feedback path?

2. Will this increase the noise pick up, because a large resistor in feedback path creates a high impedance node.

   

Everything works perfectly on a LTspice, but I wanted to check a few things before finalizing the board layout, and came across a TI application note which says in paragraph 6:

It is a standard procedure to use hysteresis (positive feedback) around a comparator, to prevent oscillation, and to avoid excessive noise on the output because the comparator is a good amplifier for its own noise. In the circuit of Figure 2, the feedback from the output to the positive input will cause about 3 mV of hysteresis. However, if the value of Rs is larger than 100Ω, such as 50 kΩ, it would not be reasonable to simply increase the value of the positive feedback resistor above 510 kΩ.

However, it doesn't say why a high value feedback resistor is "not reasonable".


I can definitely see good hysteresis behavior's with the 1M resistor in simulation

So, what is the drawback of High value resistor?