Hi all,
I’m currently building a new search engine that will search around 15,000 products and would like some general advice as to the best way to approach it.
I want to offer instant results, so the user will click an icon and the results change, no submit buttons or postbacks.
My database is MS SQL and my frontend is ASP.Net, but for this I’m looking to develop the majority of the search functionality in JavaScript.
What I’m asking really is what people recommend for the best way to approach providing instant results.
My current thinking is an initial database query loads the data into XML, then use JavaScript and XSLT to filter the XML and display the results, then as filters change these can be handled by the JavaScript and XSLT rather than going back to the database.
Does anyone have any general advice on the best performing way to provide this sort of functionality that ultimately will give the quickest results?
Thanks in advance!