InterMine performance

• Data loading performance
  • Java options
  • PostgreSQL
  • Hardware
  • Storing Items in order
  • Switching off the DataTracker
  • Non-InterMineObjects
  • Proxies
  • Results
  • Performance test
• Query performance (precomputed tables)
  • Template queries
    • Webapp
    • Command line
  • Manual specification of queries
  • Dropping precomputed tables
  • Size of precomputed tables
  • Template Summaries
  • FAQs
    • How do you know what to put in the precomputes file?
    • How do you tell if what you put in there is actually helping?
    • Were all these queries (in the flymine file) created by hand?
    • PostgreSQL is not using my precomputed table when running a query. Help!
  • A Log Entry
    • IQL
    • Generated SQL
    • Optimised sql
• Useful ObjectStore properties
  • os.query.max-query-parse-time
  • os.query.max-time
  • os.query.max-limit
  • os.query.max-offset
  • os.queue-len