{"repo":"spatie/uuid-mysql-performance","free":true,"listed":false,"github":"https://github.com/spatie/uuid-mysql-performance","clone":"git clone https://github.com/spatie/uuid-mysql-performance.git","description":"This repo contains a bunch of crude benchmark tests to test the performance of MySQL queries with UUIDs in various scenarios","language":"PHP","stars":42,"topics":["benchmark","mysql","database"],"license":null,"category":"databases-storage","readme_excerpt":"UUID performance tests This playground provides a bunch of crude benchmark tests to test the performance of MySQL queries with UUIDs in various scenarios. Read more about it here: http://mysqlserverteam.com/storing-uuid-values-in-mysql-tables/. Support us We invest a lot of resources into creating best in class open source packages. You can support us by buying one of our paid products. We highly appreciate you sending us a postcard from your hometown, mentioning which of our package(s) you are using. You'll find our address on our contact page. We publish all received postcards on our virtual postcard wall. Setup Please run composer install and setup a local MySQL database. Than copy .env.exmaple to .env and fill in your credentials in .env . Note that you can set a few configuration parameters in .env to manipulate the benchmark results. First run console.php is used to run the benchmarks, the first time around, you'll want to run the benchmark command with the --table option. This option will drop the current tables and start over again. Be aware that adding the --table option may cause the benchmark to take a lot longer to finish, depending on the amount of rows you're adding. Benchmarks Run the benchmarks with the following command. You'll probably want to keep the memory limit option, if you're setting a higher FLUSH QUERY AMOUNT . This can improve the speed at which the benchmarks are run. The Normal ID benchmark This is the baseline benchmark, executing SELECT queries","default_branch":null,"files":null,"tree":[],"storefront":"/r/spatie","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/spatie/uuid-mysql-performance/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}