We are developing a project where users can search in projects of artists, we are wondering or a normal xslt filter is fast enough, or that it's maybe smarter to do some custom sql or maybe Linq functionality.
We have something between 3 and 4000 projects, and the server is not really fast and doesn't have a very large amount of memory (about 512mb).
Can someone give me advise which will be the best way to implement a search for this?
Searching on large amount of items...
We are developing a project where users can search in projects of artists, we are wondering or a normal xslt filter is fast enough, or that it's maybe smarter to do some custom sql or maybe Linq functionality.
We have something between 3 and 4000 projects, and the server is not really fast and doesn't have a very large amount of memory (about 512mb).
Can someone give me advise which will be the best way to implement a search for this?
Assuming your projects are Umbraco content (and not custom daa via User Controls) I would check out Examine:
http://farmcode.org/post/2009/04/20/Umbraco-Examine-v4x-Powerful-Umbraco-Indexing.aspx
I use this for a relatively large site and it works GREAT!
HTH,
Nik
is working on a reply...