Posts: 507
Joined: Sep 2008
Reputation:
1
I was hoping the official Dharma 10.0 would fix it -- Anyone running XBMC live on ubtuntu (or any linux for that matter) still seeing slowness when database access is occurring? Was there a workaround figured out?
I found that when using Aeon, if I turned off the widget to display library totals it sped up the menu (saved that DB access) but any other time the DB is queried, it's still noticeably very very slow.
Thanks for any insight.
Posts: 507
Joined: Sep 2008
Reputation:
1
The weird thing is that the DB flies on my hard wired mac mini running Dharma, just not on my hard wired Linux box running Dharma. The linux box even has more memory and a better processor.
DB is hosted on a Win7 system (also fast). So the Linux box is accessing it remotely.
Posts: 2,145
Joined: Jul 2008
Reputation:
12
People have posted solutions to 'slow' database. Has to do with host resolving or something.
Code:
GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';
IF you have a mysql problem, find one of the 4 dozen threads already open.
Posts: 507
Joined: Sep 2008
Reputation:
1
Thanks. I'll dig through some past posts and see if I can find it.
Posts: 14,213
Joined: Nov 2009
Reputation:
706
Klojum
Lost connection
Posts: 14,213
If host resolving is the problem, then perhaps it's best to use IP addresses instead of hostnames. It works best for me as well when exporting/importing XBMC databases on different machines (Win + Linux).
Posts: 507
Joined: Sep 2008
Reputation:
1
I'm pretty sure I used IP addresses for all my shares on the linux machine in the mappings and on the server as well...So no resolving needed.
What would I edit in hosts.ini on my Win7 server that might speed up access for the Linux box?