hi. i'm looking for a technology who could have high performance in searching a high amount of data (nearly 10 milion lines in a convencional database like sql server) and i think PHP running under apache solr is a good choice. i have only a doubt about its possibilities.
i need to show in first place: promoted records who have all the terms searched by the user (ordered randomly). in second place: i need to show promoted records who have any term searched by the user (ordered randomly). in third place: i need the promoted records found by the stemming search (ordered randomly). in fourth place: i need the promoted records found by the phonetic search (randomly). in fifth place: the free records ordered alphabeticly. these results need to be paginated. is it possible to do that in the same task? Thanks, Paula
