• 1
  • 38
  • 39
  • 40(current)
  • 41
  • 42
  • 45
MovieLib - Your movie database on web
(2016-07-13, 11:29)Regss Wrote: I don't try on kodi 17 yet but you can try Smile

I did install it today at Krypton and saw no issues. Thanks a lot for that nice tool.
Reply
hi there,
maybe it's possible to rewrite the mysql - class for php7? you need to use mysqli_connect (e.g) because the old mysql_connect is deprecated. Smile
Reply
Edit: Deleted. Dead thread :-(
Reply
I dont know what I am doing wrong. When i Try to install script as soon as I type password I get this

Image
Reply
after many days......i just couldn't get it to work

i gave up.
Reply
Works great.
You only have to be carefull to use PHP5 on the Server than it works.

I just need to do some optimizations because with 2800+ Movies and about 20000+ TV Show Episodes it is awfully slow.
Disabling the Facebook Integration already cut down the load time of the website from 25sec to 14sec.

I have to see what i can further do to optimize load times. What are youre experinces when it comes to page load times?
Reply
(2017-02-23, 09:34)darkside40 Wrote: ...20000+ TV Show Episodes ...

Shocked

I know that optimization is needed. I gather knowledge in the field of mysql.
Changing to mysqli looks easy.

edit: If you add to any URL parameter debug= You can see what mysql query take too long.
ex. http://host/movielib/index.php?debug=
Reply
THX for the hint with the debug switch.

And i think i have identiefied the SQL Statement which is causing the delay:
SELECT DISTINCT actor.id, actor.actor FROM `actor`, `movies_actor` WHERE actor.id=movies_actor.actorid ORDER BY actor.actor - 7.9521350860596

I have tried if reducing the elements per page changes the loading time, but it does not.

Btw. this delay only effects the Movies, not the TV Shows.
Reply
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
Maybe you could send your changes needed for PHP7 to Regss? Would save him some work.

How long was it with PHP5?
Reply
Out of curiosity how many rows have yours actor table in database?
Reply
80150, which is less than in my original Kodi DB. There are 104324 rows.
Reply
I don't have that many actors in my database. Do you can check if this fix speed up load time:

open function.php and in line 515 replace from;
Code:
$sel = 'SELECT DISTINCT ' . $val . '.id, ' . $val . '.' . $val . ' FROM `' . $val . '`, `' . $table . '_' . $val . '` WHERE ' . $val . '.id=' . $table . '_' . $val . '.' . $val . 'id ORDER BY ' . $val . '.' . $val;

to:
Code:
$sel = 'SELECT ' . $val . '.id, ' . $val . '.' . $val . ' FROM `' . $val . '` ORDER BY ' . $val . '.' . $val;

and from:
Code:
$sel = 'SELECT DISTINCT `' . $val . '` FROM `' . $table . '` WHERE `hide` = 0 ORDER BY `' . $val . '`';

to:
Code:
$sel = 'SELECT `' . $val . '` FROM `' . $table . '` WHERE `hide` = 0 ORDER BY `' . $val . '`';
Reply
Tried it and it works.

Loading time reduces from approx. 12sec to 4sec. Great

This change althought only has the sideeffect that the years in the left pane are not reduced anymore.
Reply
I forgot. Undo the second change.
Reply
  • 1
  • 38
  • 39
  • 40(current)
  • 41
  • 42
  • 45

Logout Mark Read Team Forum Stats Members Help
MovieLib - Your movie database on web8