Hey guys and gals...
I'm trying something new and hoping it works.
I have a large collection of movies, cartoons and music that over the years it has grown to over 35TB and growing !!
I want to create a database that will allow me integrate into a internal site im building so it speeds up the search feature, more or less like an indexing service, but i also want it to retrieve information about the file to be displayed.
As an example:
Movies - Thumbnail / Year / Genre / Plot / Actors
Music - Album Art / Artist / Album / Year / Song
I have about 100GB set aside for this "indexing" service across 4x 36GB 15K SAS drives ( RAID5 ) that are going to be running just dedicated for this.
This would speed up the site and make a query simple and fast as all the info is stored in the database and the file location and pointers to the file would reduce search times on the larger slower drives and allowing the system to take advantage of the smaller faster drives.
Queries would be done through IMDB which would have the information listed, just need to point the database to pull the right files and data off the website.
Any input would be greatly appreciated !!
Working with SQL2012 but haven't found a newbie section on there...