Well, the (boolean) search seems to fly and the most-wanted page seems to
run smoothly, but the orphans-page get a time-out because it takes more than
30 seconds to compute. I'm baffled by this because on my little PC the
most-wanted pages takes about 5 times as long as the orphans page. Is there
a way for me to get access to the database to see what's going on? Perhaps
someone could check if all the indexes for linked are actually defined? I
also would like to know if there are perhaps a big amount of duplicates
there. I would like to know what the results of
SELECT COUNT(*) FROM linked;
and
SELECT COUNT(*) FROM linkes GROUP BY linked_from, linked_to ;
to see if they are very different. Perhaps a new log of the slow queries
would also be helpful.
-- Jan Hidders
run smoothly, but the orphans-page get a time-out because it takes more than
30 seconds to compute. I'm baffled by this because on my little PC the
most-wanted pages takes about 5 times as long as the orphans page. Is there
a way for me to get access to the database to see what's going on? Perhaps
someone could check if all the indexes for linked are actually defined? I
also would like to know if there are perhaps a big amount of duplicates
there. I would like to know what the results of
SELECT COUNT(*) FROM linked;
and
SELECT COUNT(*) FROM linkes GROUP BY linked_from, linked_to ;
to see if they are very different. Perhaps a new log of the slow queries
would also be helpful.
-- Jan Hidders