christopher-rauch

** Setup **
Virtual users: 100
Query: Get all reviews by business ID
Result: 500 RPS
 
 execution: local
     output: -
     script: database/script.js

    duration: -,    iterations: -

christopher-rauch

Tracing session: 3bcb5030-7a94-11ea-9e81-f57c5affab7f

 activity                                                                                                             | timestamp                  | source    | source_elapsed | client
----------------------------------------------------------------------------------------------------------------------+----------------------------+-----------+----------------+-----------
                                                                                                   Execute CQL3 query | 2020-04-09 11:59:26.515000 | 127.0.0.1 |              0 | 127.0.0.1
 Parsing select * from reviewsByRestaurant where businessName = 'Douglas - Rosenbaum' ; [Native-Transport-Requests-1] | 2020-04-09 11:59:26.515000 | 127.0.0.1 |            109 | 127.0.0.1
                                                                    Preparing statement [Native-Transport-Requests-1] | 2020-04-09 11:59:26.515000 | 127.0.0.1 |            188 | 127.0.0.1
                               

christopher-rauch

CREATE TABLE restaurants (
  business_id INT NOT NULL AUTO_INCREMENT,
  business_name VARCHAR(255) NOT NULL,
  PRIMARY KEY (business_id)
);

CREATE TABLE reviews (
  review_id INT NOT NULL AUTO_INCREMENT,
  rating INT NOT NULL,
  comment VARCHAR(2000) NOT NULL,

christopher-rauch

Post new review

Create a new review entry on database.

• URL

  /api/restaurants/:id/newreview
  

• Method: