Project:freelinking
Version:6.x-1.8
Component:Code
Category:bug report
Priority:minor
Assigned:Unassigned
Status:postponed

Issue Summary

Hello,

I turned on log-queries-not-using-indexes on my /etc/my.cnf and i found in a day more than 65000 lines like this:

# Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 3601
SELECT hash FROM freelinking WHERE phrase = 'something';

this apparently does not cause any performance issue (but i am on a i975 quadcore so it is difficult to notice).
To reduce the indexed queries of my installation i set up an index like this:

ALTER TABLE `my_drupal`.`freelinking` ADD INDEX `phrase_key` USING HASH(`phrase`);

and afther that, no more "SELECT hash FROM..." are appended to the mysql.slow.log

This is not a bug or a performance issue, but it is a good pratice to use properly indexed queries.

The most of the times the performance issues arise as a sum of unindexed queries made to the db.

And thank you for the good module.

Comments

#1

Status:active» postponed

Thank you very much for looking into this. The Freelinking database structure is an aging beast and should most likely get an overhaul. The next version of Freelinking will be dropping the database to avoid this kind of problem.

I welcome any reviewed patches to freelinking.install, but I won't be delving into it any time soon.