MovieLib - Your movie database on web
I use movielib a long time. I have about 1600 movies and 254 tvshows with about 18000 episodes. Recently i need to change my server and i switched to php7.
The movie index page takes less than 3 seconds to load.
Code:
SELECT id, title, date_added, hide FROM movies WHERE hide=0 ORDER BY date_added DESC LIMIT 10 - 0.00031805038452148
SELECT id, title, hide FROM movies WHERE hide=0 ORDER BY play_count DESC LIMIT 10 - 0.00022482872009277
SELECT id, title, last_played, hide FROM movies WHERE hide=0 ORDER BY last_played DESC LIMIT 10 - 0.00024819374084473
SELECT id, title, rating, hide FROM movies WHERE hide=0 ORDER BY rating DESC LIMIT 10 - 0.00025081634521484
SELECT DISTINCT actor.id, actor.actor FROM `actor`, `movies_actor` WHERE actor.id=movies_actor.actorid ORDER BY actor.actor - 0.085211992263794
SELECT DISTINCT genre.id, genre.genre FROM `genre`, `movies_genre` WHERE genre.id=movies_genre.genreid ORDER BY genre.genre - 0.00066089630126953
SELECT DISTINCT country.id, country.country FROM `country`, `movies_country` WHERE country.id=movies_country.countryid ORDER BY country.country - 0.00053119659423828
SELECT DISTINCT `year` FROM `movies` WHERE `hide` = 0 ORDER BY `year` - 0.0020380020141602
SELECT DISTINCT director.id, director.director FROM `director`, `movies_director` WHERE director.id=movies_director.directorid ORDER BY director.director - 0.0038180351257324
SELECT DISTINCT `set` FROM `movies` WHERE `hide` = 0 ORDER BY `set` - 0.0026721954345703
SELECT DISTINCT studio.id, studio.studio FROM `studio`, `movies_studio` WHERE studio.id=movies_studio.studioid ORDER BY studio.studio - 0.0020570755004883
SELECT play_count, hide FROM movies WHERE hide=0 - 0.0011999607086182
SELECT movies.id FROM movies WHERE movies.title LIKE "%%%" AND movies.id LIKE "%" AND movies.play_count >= 0 AND movies.hide=0 ORDER BY title ASC - 0.010112047195435
SELECT movies.* FROM movies WHERE movies.title LIKE "%%%" AND movies.id LIKE "%" AND movies.play_count >= 0 AND movies.hide=0 ORDER BY title ASC LIMIT 0, 50 - 0.00072193145751953
SELECT movies.date_added FROM movies ORDER BY movies.date_added DESC LIMIT 0, 1 - 0.00021696090698242
SELECT genre.id, genre.genre FROM genre, movies_genre WHERE movies_genre.id = "912" AND genre.id = movies_genre.genreid - 0.00041508674621582
SELECT actor.id, actor.actor FROM actor, movies_actor WHERE movies_actor.id = "912" AND actor.id = movies_actor.actorid ORDER BY movies_actor.order - 0.00039005279541016
SELECT country.id, country.country FROM country, movies_country WHERE movies_country.id = "912" AND country.id = movies_country.countryid - 0.00019311904907227
SELECT director.id, director.director FROM director, movies_director WHERE movies_director.id = "912" AND director.id = movies_director.directorid - 0.00018310546875
SELECT studio.id, studio.studio FROM studio, movies_studio WHERE movies_studio.id = "912" AND studio.id = movies_studio.studioid - 0.00024890899658203
SELECT * FROM `movies_stream` WHERE id = "912" - 0.00026202201843262
Reply
 
Thread Rating:
  • 8 Vote(s) - 4.63 Average


Messages In This Thread
RE: MovieLib - Your movie database on web - by _Andy_ - 2017-02-26, 19:39
Last Post - by Jeffreywat - 2017-09-03, 14:02


Logout Mark Read Team Forum Stats Members Help
MovieLib - Your movie database on web4.638