The times shown are for runs of executing each query osprey.cs.swarthmore.edu (one of the machines in 256). First, here is an example use of createDB.py where I am saving my result in /local/asas/ (you are not required to use time, this is just to give you an idea of how long my script takes to run):

$ cd cs44/labs/Lab4-asoni1/
$ time python3 createdb.py /local/asas/movie.db
File already exists; enter 0 to quit and 1 to remove: 1
Creating new movie database!

...Creating Tables...
...Inserting Records...
...Building Indexes...

real    1m5.695s
user    0m53.014s
sys 0m10.565s

Here is an example of queryDB.txt:

$ python3 queryDB.py /local/asas/movie.db

Welcome to the Movie Database!

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 1

24 results; Completed in 0.000 seconds

fname                lname
----------------------------------------
André the Giant
Anne                 Dyson
Betsy                Brantley
Billy                Crystal
Carol                Kane
Cary                 Elwes
Chris                Sarandon
Christopher          Guest
Derek                Pykett
Fred                 Savage
Garrett              Brawith
Lauren               Mora
Malcolm              Storry
Mandy                Patinkin
Margery              Mason
Mel                  Smith
Paul                 Badger
Peter                Cook
Peter                Falk
Regan                Burns
Rob                  Reiner
Robin                Wright Penn
Wallace              Shawn
Willoughby           Gray

Query Plan:
-----------
SEARCH TABLE Movie...
#result redacted as it reveals indices I built


Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 2

Please enter actor's first name: Samantha
Please enter actor's last name: Goldstein

4 results; Completed in 0.000 seconds

title
--------------------
Anywhere But Here
Firetrap
Surfer Girl House
The Three Faces of Phoebe

Query Plan:
-----------
...

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 2

Please enter actor's first name: Kevin
Please enter actor's last name: Bacon

[~215-230 results] Completed in 0.001 seconds

title
--------------------
'Hollow Man': Anatomy of a Thriller
(#1.2)
(#1.8319)
[more results]
You Don't Know Jack: Volume 2

Query Plan:
-----------
...

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 3

Please enter first actor's first name: James
Please enter first actor's last name: Stewart
Please enter second actor's first name: Katharine
Please enter second actor's last name: Hepburn

[10-15 results] Completed in 0.000 seconds

id                   title
----------------------------------------
86099                America at the Movies
150873               Fonda on Fonda
[more results]

Query Plan:
-----------
...

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 4

[~50 results] Completed in 0.163 seconds

fname                lname                FilmCount
------------------------------------------------------------
Ellen                Brown                2270
[mores results]
Paul                 Miller               506

Query Plan:
-----------
...

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 5


[~20 results]; Completed in 0.038 seconds

fname                lname                NumFilms
------------------------------------------------------------
Kyra                 Sedgwick             18
[More results]
#You'll get Tom Hanks as your top result if you double-count movies with multiple roles]

Query Plan:
-----------
...

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 6

[~25 results]; Completed in 0.404 seconds

fname                lname                title                NumRoles
--------------------------------------------------------------------------------
Scott                Morales              Is This a Joke?      8
Nicky                Figueredo            Is This a Joke?      8
[more results]

Query Plan:
-----------

Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 0


Thank you for using the Movie Database!