Requirements
- Python 3.8 or higher
- No external packages required (uses
sqlite3,time,statisticsfrom standard library)
Verify Python Version
python3 --version
# Expected: Python 3.8.x or higherRunning the Lab
- Save the complete code from
README.mdaslab01.py - Run:
python3 lab01.py - Observe the output — query count and timing for each approach
Expected Runtime
Under 5 seconds on any modern machine. The SQLite in-memory database eliminates network latency, so the benchmark is measuring pure query overhead.
Troubleshooting
`sqlite3` not found: Install Python with its standard library. On Ubuntu: sudo apt install python3.
Results show 0ms: Your machine is very fast. The speedup ratios are still meaningful. Add the simulated RTT from Extension Exercise 1 to see realistic numbers.