How I cut GTA Online loading times by 70%

Re:How I cut GTA Online loading times by 70% by brianberns on Sunday February 28, 2021 @04:07PM (#26297066)

They probably add more entries over time (and maybe update/delete old ones), so you’d have to be careful about keeping the local DB in sync.

[ Parent | on HN ]

Re:How I cut GTA Online loading times by 70% by bombcar on Sunday February 28, 2021 @05:14PM (#26297604)

So just have the client download the entire DB each time. Can’t be that many megabytes.

[ Parent | on HN ]

Re:How I cut GTA Online loading times by 70% by Twirrim on Sunday February 28, 2021 @09:34PM (#26299123)

I did a very very ugly quick hack in python. Took the example JSON, made the one list entry a string (lazy hack), repeated it 56,000 times. That resulted in a JSON doc that weighed in at 10M. My initial guess at 60,000 times was a pure fluke!

Dumped it in to a very simple sqlite db:

    $ du -hs gta.db
    5.2M    gta.db

Even 10MB is peanuts for most of their target audience. Stick it in an sqlite db punted across and they'd cut out all of the parsing time too.

[ Parent | on HN ]