Page 1 of 1

MySQL or txt for counter hosting?

Posted: Mon Jan 22, 2007 5:10 am
by kreoton
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?

Posted: Mon Jan 22, 2007 8:49 am
by feyd
MySQL would likely run faster.

Posted: Mon Jan 22, 2007 9:23 am
by kreoton
in one forum i got answer:
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
Maybe you know some examples of using FiFO?

Posted: Mon Jan 22, 2007 9:50 am
by feyd
It's basically a queue that's stored somewhere (in this case a text file) where you can stage updates for later incorporation into the database.

FIFO being First In, First Out.