A friend of mine told me that MySQL might soon store databases in RAM,
and synchronize to the disk every now and then. I had thought about
trying to accomplish this with MythTV. Since I know when the changes are
made to the database, I know when is a good time to synchronize (for
example, right after mythfilldatabase or after indexing music). I still
haven't gotten MythTV to work (waiting for my new soundcard to arrive),
but I was wondering if anyone had any ideas about it, or if anyone can
forsee a technical problem with it. The main reason I want to do this is
that I have a ton of RAM and MythTV seems to be fairly disk-intensive. I
hypothesize that queries made to RAM will be much quicker than queries
made to disk.
and synchronize to the disk every now and then. I had thought about
trying to accomplish this with MythTV. Since I know when the changes are
made to the database, I know when is a good time to synchronize (for
example, right after mythfilldatabase or after indexing music). I still
haven't gotten MythTV to work (waiting for my new soundcard to arrive),
but I was wondering if anyone had any ideas about it, or if anyone can
forsee a technical problem with it. The main reason I want to do this is
that I have a ton of RAM and MythTV seems to be fairly disk-intensive. I
hypothesize that queries made to RAM will be much quicker than queries
made to disk.