there is no index on the filepath column in the files table, which causes the query on line 149 of upload.module in upload_file_download() to be very slow when there are large numbers of rows in the {files} table

Comments

Wesley Tanaka’s picture

Wesley Tanaka commented
Title: performance: slow query in upload_file_download() » performance: missing index for query in upload_file_download()

This can be worked around if you are using MySQL by running this query:

ALTER TABLE dbprefix_files ADD KEY (filepath);

steven jones’s picture

steven jones commented
Version: 6.10 » 6.x-dev

Looks like this would still be an issue in the current D6 release.

Status: Active » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.