Only solr or with Mysql -

I want to use solr for my search index. Am I confused, should I put the data field in the solr, or search for the ID only, then get data from MySQL, please help. Which is faster, better

I only had one question in 2010 that as a search index only In order to take Solar, it was decided to get the list of IDs in the first phase, which reads MySQL data related to ID in the second phase. It works well in the environment with 20 million docks.

During the reconstruction of the entire application in 2014, we decided to store the data in the solar (not just indexing) a search throughout the docs, so that MySQL connect is no longer necessary.

We are talking about a web - only application with maximum 1-3 thousand parallel users and there is absolutely no difference in the application speed between 2010 and 2014.

But if you take a document from Solar, MySQL is not

P>

The application code is a bit cleaner.
You only need to be connected to get the data ....
But: The main reason why we store the document in solar: It is only necessary to use the highlighting feature, it is only good Will work well, if you store docs on sulter and bring them from solar BTW: If you store docs or not, there is no change in search performance.

The disadvantage is that you have to catch the data twice: 1.) in the form of a base dataset in MySQL and
2.) for your application in Solar.

And: If you have very large documents, perhaps solr is probably not the right tool to serve such types of documents.