Skip to content

GitLab

  • Menu
Projects Groups Snippets
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • D DataEngineering
  • Project information
    • Project information
    • Activity
    • Labels
    • Planning hierarchy
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 10
    • Issues 10
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar

Diese GitLab Instanz ist nicht für den produktiven Einsatz gedacht!
Bitte https://gitlab.ost.ch benutzen!
Diese Instanz ist nur nuch zur Datenmigration online.

Vielen Dank für euer Verständnis.

  • Lehre und Unterricht
  • Datenbank- und Informations-Systeme
  • DataEngineering
  • Issues
  • #25

Closed
Open
Created Apr 04, 2017 by Marcel Huber@m1huberOwner3 of 3 tasks completed3/3 tasks

provide docker container with medium size dell-dvdstore postgresql database

Context

  • Indexes
  • Optimization

Summary

Using the small sized dvdstore dataset, it is sometimes difficult to see effects of optimization. Therefore it would be better to use a larger dataset where the effects of optimization make a real difference.

Steps to reproduce

Run the queries multiple times and see that timing differs between execution and makes comparisons difficult.

What is the current issue behavior?

Depending on the query, only minimal timing differences occur.

What is the expected correct behavior?

Using a larger dataset, timing should differ much more and should make comparison of the results easier and more reproducible.

Possible fixes

  • Provide the medium size dvdstore dataset
  • Adapt exercises Indexes - [x] Optimization
Edited Aug 16, 2017 by Marcel Huber
Assignee
Assign to
Time tracking