HowTo Improve Movie & Music database speed 1,000 times - Page 2

HappyTalk · 2006-08-13, 00:45

Quote:

Originally Posted by rtv

This might be because idActor isn't unique. To fix your db try this

Re actorinfo_idActor, actorinfomovies_idActor

Hmmm yer I forgot I filled these 2 tables with dummy data during the intial migration of my myth db so the later looked unique - doh!
That said I agree actorinfomoves_idActor is clearly not UNIQUE, but actorinfo_idActor does look like it should be UNIQUE to me? and looks like it could just be merged into the actor table. I've now removed both those indexes from the Original Post as I cannot see them being used much, cheers for the pointer.

sky_diver_ · 2008-01-02, 19:59

You just saved me a couple of hours of hair pulling! And I only have a few hundred entries in movide DB! Before adding indexes configurator just slams CPU to the top, now it's vay much faster. Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
(original thread) US/Canadian/Mexico EPG Zap2it Plugin Released	bradsjm	zap2it (discontinued)	513	2007-02-21 15:07
(original thread) MyFilms v3.1 - Use an ANT Movie Database (AMC) in MP	zebons	My Films	201	2007-02-12 09:27
Help with TVServer and client	rick78	Get Support	8	2006-12-12 19:48
My Music - need your thoughts on how to improve and enhance	SteveV	Listen Music	588	2006-12-07 11:07
0.2.1 and latest svn MyPictures thumbnails broken	gloomyandy	Codecs, External Players	1	2006-10-24 11:01

2008-01-02, 19:59	#12 (permalink)
sky_diver_ Portal User Join Date: Jan 2008 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts	You just saved me a couple of hours of hair pulling! And I only have a few hundred entries in movide DB! Before adding indexes configurator just slams CPU to the top, now it's vay much faster. Thanks!