<story><title>Analyzing iMessage with SQL</title><url>https://arctype.com/blog/search-imessage/</url></story><parent_chain></parent_chain><comment><author>radicality</author><text>If you are on Mac, open up your Messages and go to any thread with some historical messages. Now scroll up to load past messages, and do that a few times. How slow is that for you?&lt;p&gt;For me, when I scroll up to load historical data, it takes always multiple _seconds_. This is on the newest, highest specced m1 macbook. What the hell is it doing in that time? Multiple seconds to do read-only queries a &amp;lt;100MB sqlite DB (and sqlite can be incredibly fast), on an SSD with &amp;gt;5GB&amp;#x2F;s read speeds, with 64GB of ram (where the whole sqlite can&amp;#x2F;should be loaded into memory), to render a blue bubble with some text inside.&lt;p&gt;What is Messages doing, and why is it so bad and inefficient. I&amp;#x27;m certain the local sqlite db has the data I need because the above bothered me so much i wrote some scripts to read my historical chats from the cli. Quality of Apple software is certainly not increasing but going downhill, you see that across many of their apps.</text></comment>
<story><title>Analyzing iMessage with SQL</title><url>https://arctype.com/blog/search-imessage/</url></story><parent_chain></parent_chain><comment><author>Cthulhu_</author><text>Must be just me or an American thing, but imessage isn&amp;#x27;t used nearly as much here; probably because Android takes up 80% market share, so people stick to cross-OS applications like Whatsapp.</text></comment>