Neo4j Vs MySQL Queries

## MySQL Read Queries

-- SELECT * FROM Songs as s
-- WHERE id = 10000000;
~ .1 ms

## MySQL Queries for related songs

-- SELECT * FROM Songs as s
-- LEFT JOIN Song_to_songs as sts
--   ON s.id = sts.songId
-- RIGHT JOIN Songs as s2 
--   ON s2.id = sts.relatedSongId
-- WHERE s.id = 1;

~ 7ms

## Neo4j Read queries

MATCH (s:Song { id: 10000000 }) 
RETURN s

~ 6ms

## Neo4j Read Song by id, and grab all related songs, as well as the artist who made that song, and playlists and albums that the song is in

Match (user:User {id: 133})-[:CREATED]->(songs)-[:RELATED_TO]-(relatedSongs)-[:IS_IN]-(albums)
WITH user, songs, relatedSongs
MATCH (songs)-[:IS_IN]->(albums)
return user, songs, relatedSongs, albums

~ 6ms