alter table file_revisions drop primary key, add primary key (vid, fid);

see:

http://lists.drupal.org/pipermail/development/2007-January/021581.html

CommentFileSizeAuthor
#1 swap_file_revision_index.patch.txt840 bytesgerhard killesreiter

Comments

gerhard killesreiter’s picture

gerhard killesreiter commented
Status: Active » Needs review
StatusFileSize
new swap_file_revision_index.patch.txt840 bytes

here is a patch. pgsql part is missing, no idea if it would be neccessary.

RobRoy’s picture

RobRoy commented
Status: Needs review » Needs work

And all these new/modified keys should be included in system_install() as well and (maybe) for pgsql.

Crell’s picture

Crell commented

Using ab with a hitcount of 100 on a fresh HEAD, 10 nodes on the front page, 3 with attachments, and MySQL query cache off. I didn't see any appreciable difference with this patch. Both before and after, multiple ab runs hovered between 304 and 310 mean ms per request.

Also, you're missing an underscore in the table name. :-)

Crell’s picture

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

No progress and didn't accomplish anything anyway.