Query execution speed-up: The investigation

From phenoscape
Revision as of 20:16, 30 January 2009 by Crk18 (talk | contribs) (New page: A number of potential factors affect the performance of the queries that are executed on the Phenoscape database. These can be classified under a few major categories: * Hardware: This ha...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

A number of potential factors affect the performance of the queries that are executed on the Phenoscape database. These can be classified under a few major categories:

  • Hardware: This has to do mainly with the database server configuration
  • RDBMS
  • Database schema
  • Querying strategy

The last category has been discussed at some length in the Queries page. This page mainly presents the findings in the other categories and proposes possible steps to improve these

Retrieved from "https://wiki.phenoscape.org/wg/phenoscape/index.php?title=Query_execution_speed-up:_The_investigation&oldid=5327"