1. Number of Queries
2. Number of Duplicate Queries
3. Sql Query itself
4. Time taken to Query DB
1. git clone https://github.com/ashiqYousuf/sqlqm.git
2. Change directory to root dir (sqlqm)
3. Create virtualenv & activate it
4. Install requirements: pip install -r requirements.txt
5. Run migrations: python3 manage.py migrate
6. Populate dummy data for testing as:-
. activate virtualenv
. python manage.py shell (and write following lines in shell)
. from sqlquery.factory import *
. ProductFactory.create_batch(100) # This will create 100 products in DB.
7. Start server: python3 manage.py runserver <PORT>