mardi 9 août 2016

How to get more speed form Query?

I'm using PHP-Mysql for my project, and i have a table with more 30000 rows.

When my code access to that table, request time too long.

How i can get more speed? or some way to do that?

I'm using Laravel 5.1. My code like this:

Games::join('categories', 'categories.id_game', '=', 'games.id')->where('games.id', $id)
->select('games.*', 'categories.name')->get()->toArray();

Table Games has more 30000 rows and i used index(id) for table Games.

Sorry about my English!



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire