Download & Extend
Issues

Index on nid in the files table.

Posted by msameer on November 22, 2006 at 9:22am
Project:Drupal core
Version:6.x-dev
Component:file system
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (won't fix)

Issue Summary

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 ?

Login or register to post comments

Comments

#1

Posted by killes@www.drop.org on November 22, 2006 at 10:00am
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.

#2

Posted by msameer on November 22, 2006 at 10:15am

Patch against 5.0 beta1

AttachmentSizeStatusTest resultOperations
drupal_files_nid_index.patch647 bytesIgnored: Check issue status.NoneNone

#3

Posted by spatz4000 on April 2, 2007 at 3:01pm
Version:5.x-dev» 6.x-dev

#4

Posted by merlinofchaos on July 10, 2007 at 5:11pm
Status:active» needs review

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

#5

Posted by msameer on July 14, 2007 at 12:27pm
Status:needs review» needs work

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

#6

Posted by drewish on September 5, 2007 at 8:10pm
Status:needs work» closed (won't fix)

there's no longer a files.nid column.