Out of memory errors and timeouts

[shqiperih]

Hi,

I have a rather large channel line (14000 (they are VOD listings)).
These channel list load fine on nextpvr itself.
However i have problems when trying to use any other client like nextpvr for kodi or for plex.

At the beginning i thought these were issues with he clients. But even the webclient on npvr has had issues (at least lately with the additions of logos because it used to do them without logos before)
But i used a smaller source of channels (7000) and they work fine.

then i looked at logs and saw this error:

2018-04-22 16:38:02.877 [ERROR][32] System.Data.SQLite.SQLiteException (0x80004005): out of memory
out of memory
at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()



What is the best way to deal with this?(i am hoping not to manually change the channel list) is there any settings to modify to fix things?

Let me know if you need more info

thank you!

[sub]

I'm not familiar with that error, but you if you can supply your npvr.db3, I'll see if I can reproduce it here with your channel line up.

[shqiperih]

Included db3 file.

Please check pm on open instructions.

thank you!