Index on nid in the files table.
msameer - November 22, 2006 - 09:22
| Project: | Drupal |
| Version: | 6.x-dev |
| Component: | file system |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | won't fix |
Description
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 ?
#1
it is probably a good guess. :p
I think a patch for this makes sense, but I am moving it to HEAD.
#2
Patch against 5.0 beta1
#3
#4
This probably would get more attention if labeled as a patch.
#5
I can't mark it as needs review while I know it's not.
#6
there's no longer a files.nid column.