Sonic and Sega Retro Message Board: Glitch - Viewing Profile - Sonic and Sega Retro Message Board

How you store the data will depend on what you want to do with it once it's on disk.

Both fread and fopen will require syscalls so they'll have the context switching overhead. If you're going for read speed you'll want to avoid that like the plague, so big files with sizeable read buffers would be ideal. From what you've said it looks like you'll be querying based on date ranges so I'd suggest:

Use big files with a fixed size limit. Keep appending rows until you hit that limit then start a new file. Maintain a separate index file containing your date values with pointers to your data in the fixed size files.

The main problems with lots of small files are: a). most filesystems don't cope very well with directories with many small files (you'd need something like rieserfs), and b). if you're on a shared VPS chances are you've got an inode limit.

So, yes, I'm suggesting you build your own basic database.

You can't go wrong with a T-Shirt.

Does this cover donors that give a small amount on a monthly basis? I've had a Paypal monthly recurring payment set up since Oct 2011 which is relatively small in isolated amounts but over the course of a year it would be over the $50 mark.

Nice work Esrael. That level editor is much better than Aspect Edit for S2SMS.

I can probably chip in too. Who's taking the lead?

Just a minor find: there's a camera debug routine included in the ROM. The byte at $0064 is used as a debug flag register. The 2nd bit of this byte enables the debug routine (I.e. hex edit address $64, changing the value to $02). When you're in a level, hold button 1 and use the D-pad to move sonic/the camera around. Release button 1 to place Sonic at that position. Interestingly, there's no hint of this address in the final but it was also used in Triple Trouble.