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
This is my favorite show. And this is my favorite tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koophttps://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton