Woa….. if you have queries in queries and subqueries and so forth, I personally would look into your code and try to find other ways. "IN" or alike could help a lot.
Also, OpenBD has a new caching function that is really smart and you can even leverage Memcached or MongoDB. It helped our deployments a lot. Docs are at http://www.openbd.org/manual/?/caching Kind Regards, Nitai On Thu, Aug 16, 2012 at 1:33 AM, Confused <[email protected]> wrote: > I have sales reports that end up being loops within loops within queries > within loops, the results of which are delivered to the client with a > healthy dose of jquery widgets. Some take > 20 seconds to load and render. > > Admitted, there are a hundred places to burn time in there. > Without question, some of them are far more significant than a pre-compile. > (code & db design, and strength of hardware to start with) > > And I agree that the vast majority of time, pages load too fast to be > worrying about any of this. > > But when pages start taking 20 seconds, I start looking for ways to make 'em > faster. > > Driving habits are probably the most significant aspect of gas mileage, but > if you're trying to get the best mileage, you wouldn't ignore tire > maintenance and tune-ups, would you? > > Plus, I would really like to know whether I pay a price at all for my rather > verbose coding style. > > tx, > c > > > > > On Thursday, August 9, 2012 7:05:05 PM UTC-5, Confused wrote: >> >> If I remember correctly, Coldfusion had a "compiler" that would tokenize >> cfm templates. >> >> Does OBD have anything similar? >> >> tx, >> c >> > -- > online documentation: http://openbd.org/manual/ > http://groups.google.com/group/openbd?hl=en -- See for yourself how easy it is to manage files today. Join the revolution! Razuna - Hosted Digital Asset Management Solution http://www.razuna.com/ Razuna - Open Source Digital Asset Management http://www.razuna.org/ Twitter - http://twitter.com/razunahq Facebook - http://www.facebook.com/razunahq Support Platform - http://getsatisfaction.com/razuna -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en
