Bir seri ilanlar web sitesi var, ve ben bir mysql tabloda şu anda yaklaşık 100thousand reklamları var.

I am using php to fetch results and to display them on a page. However, I am noticing the searches getting slower and slower. That is why I am planning on installing and using SOLR, as I have heard good things about it.

But to my suprise, I haven't found much information on how it works exactly... Please answer these Q about SOLR and provide me with the most information you can about how it works:

1 - SOLR sadece daha hızlı, bir mysql tablo olarak aynı mı?

2- On a site which uses mysql to show ads, insert ads, search ads etc, would all the mysql need to be 'bypassed' to some SOLR function which is similiar as the mysql function? To clarify, here is an example: If I use "SELECT * FROM table WHERE id=$id" as a query-string to query the table, would I then have to use some other function which is similiar to this, but for SOLR?

3 - Ne zaman kullanıcıların insert reklamlar 'onlar mysql tabloya eklenir, bunun için bir işlev de vardır, ama SOLR için?

4 - Nasıl arama parametreleri arama-kriterlerini SOLR geçirilen ya da nelerdir?

Teşekkürler