https://community.developer.cybersource.com/t5/Integration-and-Testing/Queries-running-somewhat-slow/m-p/69805#M42761 <P class="_1qeIAgB0cPwnLhDF9XSiJM">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.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">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?</P> Sun, 24 Nov 2019 11:02:48 GMT DomnikBritto 2019-11-24T11:02:48Z https://community.developer.cybersource.com/t5/Integration-and-Testing/Queries-running-somewhat-slow/m-p/69805#M42761 <P class="_1qeIAgB0cPwnLhDF9XSiJM">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.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">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?</P> Sun, 24 Nov 2019 11:02:48 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Queries-running-somewhat-slow/m-p/69805#M42761 DomnikBritto 2019-11-24T11:02:48Z