Reply
Highlighted
Member
Posts: 1
Registered: ‎11-24-2019

Queries running somewhat slow

I've got a local mysql server set up on my laptop that has a database in that that has 31 tables. The one table I use moreso than the rest has 160 columns and ~13,500,000 entries. I'm not surprised that some of the queries can be a little bit slower than I would like.

What I am wondering is if creating a multiple-column index would help out in this case? Or is the database size combined with the fact that it's running on a laptop rather than a server where my issue really is?