Reply to thread

Message

<blockquote data-quote="doskabouter" data-source="post: 1281823" data-attributes="member: 98267">My thoughts exactly, I bet my old n95 phone would be able to return 5000 records in a reasonable time <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />Or perhaps the marshalling is a bit of a performance killer (didn't yet investigate, but it could be...)Do we need all the columns (i see a select * done, and I can imagine the calculation time will scale linearly with the number of columns involved)?Didn't check the logs but I'm assuming no busy retries are done?If this all fails to get the expected improvement, perhaps we can come up with some pagination scheme? (Although pagination and databases aren't exactly the best of friends...)And do you really want all those 5000+ entries in one list in mediaportal? that doesn't seem very useful at first sight, but can surely increase the memory usage of your system (possibly starving the sqlite part...)</blockquote>

[QUOTE="doskabouter, post: 1281823, member: 98267"] My thoughts exactly, I bet my old n95 phone would be able to return 5000 records in a reasonable time :) Or perhaps the marshalling is a bit of a performance killer (didn't yet investigate, but it could be...) Do we need all the columns (i see a select * done, and I can imagine the calculation time will scale linearly with the number of columns involved)? Didn't check the logs but I'm assuming no busy retries are done? If this all fails to get the expected improvement, perhaps we can come up with some pagination scheme? (Although pagination and databases aren't exactly the best of friends...) And do you really want all those 5000+ entries in one list in mediaportal? that doesn't seem very useful at first sight, but can surely increase the memory usage of your system (possibly starving the sqlite part...) [/QUOTE]

Verification