Sort database to optimize it?
 

Would sorting a database help speed it up? For example, making it change

pmid
pmtextid
userid
folderid
messageread

INSERT INTO pm VALUES (1,1,8393530,-1,1);
INSERT INTO pm VALUES (27954,14358,89,-1,1);
INSERT INTO pm VALUES (73985,40644,8403731,0,2);
INSERT INTO pm VALUES (50,27,8393530,-1,1);
INSERT INTO pm VALUES (3,2,8393530,-1,1);
INSERT INTO pm VALUES (4,2,126,0,2);
INSERT INTO pm VALUES (34950,18459,8400098,0,0);
INSERT INTO pm VALUES (5,3,126,-1,1);
INSERT INTO pm VALUES (6,3,8393530,0,1);
INSERT INTO pm VALUES (122522,69734,8392989,0,0);
INSERT INTO pm VALUES (7,4,8393530,-1,1);
INSERT INTO pm VALUES (8,4,126,0,1);
INSERT INTO pm VALUES (32520,17042,8399661,0,1);

to

INSERT INTO pm VALUES (1,1,8393530,-1,1);
INSERT INTO pm VALUES (3,2,8393530,-1,1);
INSERT INTO pm VALUES (4,2,126,0,2);
INSERT INTO pm VALUES (5,3,126,-1,1);
INSERT INTO pm VALUES (6,3,8393530,0,1);
INSERT INTO pm VALUES (7,4,8393530,-1,1);
INSERT INTO pm VALUES (8,4,126,0,1);
INSERT INTO pm VALUES (50,27,8393530,-1,1);
INSERT INTO pm VALUES (27954,14358,89,-1,1);
INSERT INTO pm VALUES (34950,18459,8400098,0,0);
INSERT INTO pm VALUES (73985,40644,8403731,0,2);
INSERT INTO pm VALUES (32520,17042,8399661,0,1);
INSERT INTO pm VALUES (122522,69734,8392989,0,0);

in the database. If so, would doing

SELECT pmid FROM pm ORDER BY impd;

be the command to do this, to the posts and thead tables? To stop it from spiting out something like this...

Quote:
Search took 68.66 seconds; generated 1 minute(s) ago.
(Searching for all posts by a member with 11,226 posts.)