Database sharing (12 Viewers)

[allanp81]

It sounds like it. Maybe try updating the network card drivers?

 

[naich]

Hi Richardg!

I'd also problems with the network speed by using the server solution ...

should work fine-especially if you map the network drive first and then choose the networked drive

after i mapped the "ServerDatabase" as network drive it works much better

cu

 

[RICHARDG]

Not sure what you mean by

" after i mapped the "ServerDatabase" as network drive it works much better"
I have the database on a mapped drive, but are you doing something different

 

[allanp81]

Well after a while of trying to run my databases for everything via a network location I've given up. It just always complains about delayed write to the database and then it just randomly loses entries and thumbnails etc. Would be interested to here if anyone experiences similar issues or has this all working perfectly?

 

[RICHARDG]

I have given up as well.
I get write errors, thunbs and banners that disappear.
And it takes way to long to load.

 

[allanp81]

Exactly the errors I get. It's a shame as when it's working it makes me life a lot easier.

 

[daquint]

I have gotten this to work perfectly. I am using a Gigabit network and have the thumbs directory on a media server.

My media portal machine (XP SP2) thats pulling the images,banners, etc. has the latest stable build with the latest stable plugin (i do not have SVNs running). It has the mapped network drive of Z:\thumbs ( i tried to make it as simple as possible) which is the exact path I have in the MediaPortalDirs xml file.

I would be interested in knowing if the errors come from writing to the shared, reading from the shared (or both)?

 

[keith2045]

I think the main problem is when MP tries to read the database and the other MP is currently either updating it or just reading it, it locks it so the other MP cant access it. I'm having this problem on my setup, i'm always getting no series found and if i check my error logs i see much of messages about the database being locked.

I have given up using a shared database. Actually now that i think of it i might use just one, and have one copy it over the other one, that way everything is the same.

 

[daquint]

I use the following approach.

My room PC (Vista) is the only one that is set to grab show info, art, etc. Once i have any new info added i copy my DB file and my thumbs folder to the network share - where my two slave media portal PC's grab the info. This works well for me and maybe thats why it works w/o errors (cause I am not truly sharing the DB files).

 

[allanp81]

I notice in the svn of the 15/02/08 that the sql database has been updated and it apparently now stable and less prone to data corruption. I'm gonna give this updated svn a go and see if I still encounter the same problem when trying to database share.