by drakinite » Thu Sep 07, 2023 10:34 pm
ah, that'd definitely do it, good catch! I forgot about checking the addon, but I'll bet that was put in to prevent the rendering from taking too long, because rendering 1000 rows with all of the columns from Songs takes quite a long time; and if you have a database of 100,000 tracks, it would get insane. When processing a lot of data, I think it would be a better idea to use a dedicated SQLite viewer program in my opinion, since the SQL editor is relatively barebones and isn't optimized for big queries or lots of data.
ah, that'd definitely do it, good catch! I forgot about checking the addon, but I'll bet that was put in to prevent the rendering from taking too long, because rendering 1000 rows with all of the columns from Songs takes quite a long time; and if you have a database of 100,000 tracks, it would get insane. When processing a lot of data, I think it would be a better idea to use a dedicated SQLite viewer program in my opinion, since the SQL editor is relatively barebones and isn't optimized for big queries or lots of data.