The Toolkit for Online Communities
18830 Community Members, 0 members online, 1929 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : Monitoring and Controlling Queries : One Message

Forum OpenACS Q&A: Re: Monitoring and Controlling Queries

Posted by Don Baccus on
If the query took minutes then either the datamodel has problems, they're trying to return far too many rows to reasonably display on a web page, they're missing indexes, they forgot to ANALYZE their database etc etc.
Posted by Steve Manning on

I think the answer is probably yes,yes,yes and yes. :-)

Truth is I don't have access to it at the moment to see whats going on but I suspect its badly written, returns too much and  from what I understand maintenance is 0 so ANALYZE is probably a foreign word.