3 replies to this topic

[Sterke-Jerke]

How can I limiet the size of the epg.db file more?
When I start its 18Mb. After a couple of days ut grows to a horrible 40Mb.
I allready limited the amount of days thats I retrieve.
Also made extra virtual mem.
Took out HD channels.

Whats the best way to make sure the size stays reasonable, so it will not slow down my box?
Does someone have some settings for UK and Dutch channels?




Greetz

[WanWizard]

The problem isn't in the amount of data (initially), but the fact that a SQLite database is used to store the data.

There is an issue with concurrent access to this database, so when Enigma needs to read data (for example for the service list) while something is received and processed, it will have to wait.

Reducing the about of EPG will not significantly improve this behaviour, as it is not directly related to the size of the epg.db. It is a limitation of the design,

[doglover]

The increase in size is probably my fault.

When we started out with this epg thing, we were happy to provide the program titles and times, with one or two lines description.

After I got better, the description field got more and more filled up. (although some channels still lacks description). Up to a point now where I got for the Film1 channels (durtch) almost a complete discussion and background of the movie. (Just introduced this weekend - under a different service reference)

Since I do not have an enigma1 machine anymore, I did not notice the dramatc increase in epg.db. However I still keep the files in ISO-8859-1 so enigma1 users can still download this data. It should be easier for me if I could do everything in UTF-8. Enigma2 understands this, but the epg importer in in enigma1 does not.

Willy

PS: example of the new info for film1 Action:

Film1 Action Nobel Son
20:30 110 min. 2007.
22:20 Misdaadkomedie waarin de zoon wordt ontvoerd van een onuitstaanbare Nobelprijswinnaar (Alan Rickman), die niet van plan is te betalen voor die onzin. Barkley Michaelson worstelt met het afmaken van zijn proefschrift als zijn vader Eli, een egocentrische scheikundeprofessor, de Nobelprijs wint. Iedereen ergert zich mateloos aan het onuitstaanbare gedrag van Eli. Een dag voordat hij de prijs zal aanvaarden, wordt Barkley ontvoerd en loopt de spanning steeds hoger op: Eli weigert namelijk het losgeld voor zijn zoon te betalen.. De samenwerking tussen regisseur Randall Miller en acteur Alan Rickman beviel blijkbaar goed, want Rickman speelde na zijn vertolking van Eli in dit komische misdaaddrama opnieuw de hoofdrol in Millers film 'Bottle Shock'. Bryan Greenberg is hier te zien als Barkley. De acteur brak door met zijn rol in de serie 'One Tree Hill' en was daarna onder meer te zien in de romantische komedies 'Prime' en 'Bride Wars'.
Acteurs: Alan Rickman, Bryan Greenberg, Mary Steenburgen, Danny DeVito, Bill Pullman.

[doglover]

There is an issue with concurrent access to this database, so when Enigma needs to read data (for example for the service list) while something is received and processed, it will have to wait.

You could try to disable EIT, MHW and any other epg collection, which will reduce the writing to the epg.db file.

Willy