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