Hi,

Seems that the image module is executing queries like:

SELECT filename, filepath FROM files WHERE nid=561;

But the files table doesn't have a key on nid. I guess that adding it will improve the selects against large tables ?

CommentFileSizeAuthor
#2 drupal_files_nid_index.patch647 bytesmsameer

Comments

killes@www.drop.org’s picture

killes@www.drop.org commented
Version: 4.7.4 » 5.x-dev

it is probably a good guess. :p
I think a patch for this makes sense, but I am moving it to HEAD.

msameer’s picture

msameer commented
StatusFileSize
new drupal_files_nid_index.patch647 bytes

Patch against 5.0 beta1

stevenpatz’s picture

stevenpatz
he/him
commented
Version: 5.x-dev » 6.x-dev
merlinofchaos’s picture

merlinofchaos commented
Status: Active » Needs review

This probably would get more attention if labeled as a patch.

msameer’s picture

msameer commented
Status: Needs review » Needs work

I can't mark it as needs review while I know it's not.

drewish’s picture

drewish commented
Status: Needs work » Closed (won't fix)

there's no longer a files.nid column.