PHP REST Service is really slow

Question

I'm having a problem with my PHP REST service, it is really slow. I build it with the Flight PHP Framework. It's accessing data from a MySQL database and returns them as json.

Flight REST Service:

Flight::route('GET /categories', function(){
    header('Content-type: application/json');
    $db = Flight::db();
    $sql = "SELECT * FROM categories";
    $stmt = $db->prepare($sql);
    $stmt->execute();
    $result = $stmt->fetchAll();
    echo json_encode($result);
    $db = null;
});

The first response is very fast and the answer is returned not formatted.

After ~3 seconds the request is finished and the answer is displayed correctly.

Why does it takes so long for finishing the request?

Thanks in advance!

What if you do a request which does not require a database? Eg. return a hard-coded string like hello world? That way you can determine if the database data retrieval is the bottleneck. — ThomasMX, Mar 04 '17 at 12:04
Just a long shot but if you do $db->query instead of the prepare-execute,any change? — Mihai, Mar 04 '17 at 12:04
Have you tried restarting you server. Also check for throttling in Chrome dev settings — Peter Chaula, Mar 04 '17 at 12:05
@peter: i'm not able to restart the server because it's from a webhoster — mbauer, Mar 04 '17 at 12:24
@Mihai: doesn't change anything, still takes 3 seconds until finishing the request — mbauer, Mar 04 '17 at 12:27
@ThomasMX: the database is fast enough, I already checked that — mbauer, Mar 04 '17 at 12:28

mbauer · Accepted Answer · 2017-03-05T18:54:25.467

Finally I fixed that behavior with an exit(); call at the end of the method:

Flight::route('GET /categories', function(){
   header('Content-type: application/json');
   $db = Flight::db();
   $sql = "SELECT * FROM categories";
   $stmt = $db->prepare($sql);
   $stmt->execute();
   $result = $stmt->fetchAll();
   echo json_encode($result);
   $db = null;
   exit();
});

It takes between 50-80ms for finishing the request now.

PHP REST Service is really slow

1 Answers1