Slow Queries... What are the options?

Events happening in the community are now at Drupal community events on www.drupal.org.
nimi's picture

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

Scott Reynolds's picture

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

nimi's picture

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: