Hi,
I'm sorry if I posted in wrong forum.
I planning to make counter hosting script, there would be many data, and it should be placed somewhere, so what is better to use mysql or txt driven database?
MySQL or txt for counter hosting?
Moderator: General Moderators
in one forum i got answer:
Maybe you know some examples of using FiFO?I say do a mixture of mySQL and text files.
Counters can quickly use up MySQL connections and erver resources when they get popular.
You might consider implementing a queue or FIFO arrangement on the tracking end, then periodically (could be every few seconds or hours depending on the stats you are offering) update the database with the info that is in the FIFO.
There is less opportunity for the remote sites to use up all you database connections and/or processor cycles and compromise you server.
Mike