I have a product database with close to 3 million records. I am writing a webservice to query the db. The output will be assigned to an array in the client for string matching (exprience similar to you start type ipod in google's search box). Any suggestions on how can I optimize the query or cache it in such a way that new cache is created only upon the product refresh. The product DB will be refreshed every week with new products which means the number of records will grow over time.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire