Posted by shantanuo on August 30, 2009 at 4:54pm
Hi,
There is this query in a loop for every logged in user.
SELECT dst FROM dp_url_alias WHERE src = 'user/62025'
It is consuming a lot of MySQL resources and slowing down the site. Is it the standard query? What does it do? What should I do to stop it or increase the interval?
Comments
are you using devel?
Are you using the devel module (http://drupal.org/project/devel) to find out where the query exists? Try that if you haven't done that already, it will give you the source of this query. I believe you are using "l()" function in some loop, not sure though. Also, try to see the apache logs and if prefix of tables exists.
Mukesh Agarwal
Blisstering Solutions
Cheers,
Mukesh Agarwal
www.innoraft.com