Slow Queries... What are the options?

Events happening in the community are now at Drupal community events on www.drupal.org.
Posted by nimi on April 18, 2010 at 4:26pm

Hello everyone,

I built I a scheduel for my university that is based on views and the cck matrix fields.
There are many fields and it takes 18 seconds to load the page!

The devel module shows the the cck matrix fields are the ones slowing everything down.

Is there anyway to speed things up?

Many thanks,
Nimi.

Comments

If it is CCK you can try

Posted by Scott Reynolds on April 18, 2010 at 8:48pm

If it is CCK you can try this. http://drupal.org/node/372994

Views 2.6 and greater have Caching plugins. These cache the query results so hopefully, only the first time the query happens its slow.

But in the end it really depends on the query that you are using. Some times just deciding that having X field isn't totally necessary especially if it speeds it up.

I have caching enabled but it

Posted by nimi on April 19, 2010 at 1:59pm

I have caching enabled but it still is a burden on the system.
The solution in the link you attached is certainly interesting but it still requires more work.

Are their other ways of optimizing views with cck?

Views Developers

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

AltStyle によって変換されたページ (->オリジナル) /