Performance Issues Indexes : I added the following indexes: CREATE INDEX File_JobId_idx ON File(JobId); CREATE INDEX File_PathId_idx ON File(PathId); CREATE INDEX File_FilenameId_idx ON File(FilenameId); CREATE INDEX Path_PathId_idx ON Path(PathId); CREATE INDEX Job_FileSetId_idx ON Job(FileSetId); CREATE INDEX Job_ClientId_idx ON Job(ClientId); CREATE INDEX File_FilenameIdPathId_idx ON File(FilenameId,PathId); This reduced dbcheck time from >24 hours to a few *seconds*. [...]
Mon, 17 Jan 2011 13:30:17 +0000
|