Hi,
My company have a site of ads that have 2 types of data:
active ads (ads that are valid) and inactive ads (that are no longer valid,
but we have to show the page to get users to see related ads , related
searches, etc).
Some doubts crossed the mind of the team:
- · Should we do 2 indexes one for each status, or only one with
a “flag” of active/inactive? Will it impact the performance? Can we make
something that will “partitionate” our index guided by this field, for that
matter?
- · We are thinking, orientated by a consultant company, to do a
full indexing monthly or near. If we get the data directy form our database,
what do you think is the best, without think n the software license:
Microsoft SQL Server or MySQL? I saw an article that encourage us to make it
with MySQL:
http://www.cabotsolutions.com/blog/200905/using-solr-lucene-for-full-text-search-with-mysql/
[]s
Paulo Marinho
