Forum ‹ BigDB ‹ Logging?

[NPSF3000]

I would like to implement logging. For example - to log log-in attempts

Before reinventing the wheel, I was wondering if anyone else had some tips and tricks?

My main concerns are:

Not maxing any DBO 500KB limit.
Not wasting bandwidth (e.g. looking up big DBO's).
Not using excessive amounts of DBO's.
Do all of the above under hostile conditions.

I will probably create a client application to periodically (daily or less) collect old data, parse it, and clean it out of bigDB. Just need to figure out how to sync it.

[garysimmons]

Hi,

Haven't tested it myself yet but what about logging to a separate mysql database via the Web class. That way you can just post the data off to a php script that then takes care of putting it in the database.

This is probably what I am going to try for the following reasons.

No 500kb limit
Don't end using BigBD DBOs wastefully.
Once the web request has been fired your app can kind of forget about it
If the call to the php script fails for some reason its not critical to the running game


Anyway...just a few thoughts which might help

[garysimmons]

also if you are using Unity you can use wwwform class to also log to the same database from the client as well to keep both client and server logs all under one roof.

[NPSF3000]

I've no real experience with MySQL or PHP - so the that's too expensive by default.

I do have plans to start implementing my own DB solution - but it's going to be months before it's battle ready

Thanks anyway

[jasonMcIntosh]

logging to a separate mysql database via the Web class. That way you can just post the data off to a php script that then takes care of putting it in the database.

+1