Tony Reed DI-Tony-Reed

## db_normalization_performance.sql
/*
Demonstrates the performance difference of using normalized DB tables vs JSON/CSV in a single column to store data
Assumes you are using MySQL 8.x+ locally
https://dev.mysql.com/blog-archive/mysql-explain-analyze/
*/

CREATE TABLE users_test_not_normalized
(
    id          int PRIMARY KEY,
    name        varchar(100),

## urlChecker.go
package main

import (
	"fmt"
	"net/http"
	"time"
)

const numberOfRequestsPerURL int = 10
	/*
	Demonstrates the performance difference of using normalized DB tables vs JSON/CSV in a single column to store data
	Assumes you are using MySQL 8.x+ locally
	https://dev.mysql.com/blog-archive/mysql-explain-analyze/
	*/

	CREATE TABLE users_test_not_normalized
	(
	id int PRIMARY KEY,
	name varchar(100),
	package main

	import (
	"fmt"
	"net/http"
	"time"
	)

	const numberOfRequestsPerURL int = 10