diff options
| author | ByteHamster <ByteHamster@users.noreply.github.com> | 2024-04-04 21:58:36 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-04-04 21:58:36 +0200 |
| commit | 0288d4e51eb7eef565be8d814fb8c152383e5031 (patch) | |
| tree | 39c16b63f4d5503df2e08fe07b959c6bed40b678 /core/src | |
| parent | e894ff1ccb279237be2ab04063d1f7505b30a86f (diff) | |
| download | AntennaPod-0288d4e51eb7eef565be8d814fb8c152383e5031.zip | |
Small database efficiency tweaks (#7058)
- When checking whether there is a subscription, there is no need to create feed objects (plus counters etc). Just the number of episodes is enough.
- Downloads section only needs to load the items it actually displays.
- No need to load FeedMedia, just to load FeedItem including the same FeedMedia afterwards.
- No need to convert columns to Strings and back to Longs.
- No need to join favorites when we are only interested in the list of IDs anyway.
Diffstat (limited to 'core/src')
| -rw-r--r-- | core/src/test/java/de/danoeh/antennapod/core/storage/DbWriterTest.java | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/core/src/test/java/de/danoeh/antennapod/core/storage/DbWriterTest.java b/core/src/test/java/de/danoeh/antennapod/core/storage/DbWriterTest.java index 5aa81ea35..806b8f08f 100644 --- a/core/src/test/java/de/danoeh/antennapod/core/storage/DbWriterTest.java +++ b/core/src/test/java/de/danoeh/antennapod/core/storage/DbWriterTest.java @@ -246,7 +246,7 @@ public class DbWriterTest { c = adapter.getFeedItemCursor(String.valueOf(item.getId())); assertEquals(0, c.getCount()); c.close(); - c = adapter.getSingleFeedMediaCursor(item.getMedia().getId()); + c = adapter.getFeedItemFromMediaIdCursor(item.getMedia().getId()); assertEquals(0, c.getCount()); c.close(); } @@ -370,7 +370,7 @@ public class DbWriterTest { c = adapter.getFeedItemCursor(String.valueOf(item.getId())); assertEquals(0, c.getCount()); c.close(); - c = adapter.getSingleFeedMediaCursor(item.getMedia().getId()); + c = adapter.getFeedItemFromMediaIdCursor(item.getMedia().getId()); assertEquals(0, c.getCount()); c.close(); } @@ -422,7 +422,7 @@ public class DbWriterTest { c = adapter.getFeedItemCursor(String.valueOf(item.getId())); assertEquals(0, c.getCount()); c.close(); - c = adapter.getSingleFeedMediaCursor(item.getMedia().getId()); + c = adapter.getFeedItemFromMediaIdCursor(item.getMedia().getId()); assertEquals(0, c.getCount()); c.close(); } |