Originally posted by Jeanne Boyarsky:
Not really about caching, but do you have indexes on those large tables?
Originally posted by Eugene Kononov:
[b]Not really about caching, but do you have indexes on those large tables?[b]
Yes, all tables are properly indexed and up to date. But since the tables are large, each query takes from 100ms to 300ms, and with the thousands of queries that we perform to do the calculations, the cost of database I/O is prohibitive.
Originally posted by William Brogden:
Great work Warren the ranch should save that for a FAQ
Politics is a circus designed to distract you from what is really going on. So is this tiny ad:
how do I do my own kindle-like thing - without amazonhttps://coderanch.com/t/711421/engineering/kindle-amazon