Page 1 of 1

The fastest way?

Posted: Fri Sep 03, 2010 2:32 pm
by raccer
I'm building a service that allows users to interact with an existing catalog via SMS. The catalog is accessed RESTfully with OAuth. The catalog returns data in either JSON or XML, recently it occurred to me I could speed up my service by loading the catalog to my server, and say pull updates once a day or so. I've done zero benchmarking, and my code now is not optimized for speed. (I'm just learning patterns, been coding like 6 months, about to read up on caching)

1. the idea of mirroring the catalog, in a local (same hard drive) DB, this would always be faster than a http query to a remote catalog right?
---the service will be hosted on a dedicated Intel C2D 2.5GHz, 4GB, SATA-II HD
---the catalog has 100k items, a single item is 2kb ( though I parse & only need 10-25 bytes )