How Reliable are Text files?

GonzoBeads · Post by **GonzoBeads** » Thu Aug 07, 2008 6:13 pm

Hi there,

I've noticed you've said text files can't handle large volumes of clicks - how large are we talking about?

Say I get 2000 clicks a day - is that too many?

I love the script so far! I just installed it, but I'm wondering if this will end up working for me with the volume I have planned for the links!

Thanks!
Kyle

Post by **Klemen** » Fri Aug 08, 2008 5:40 pm

It's hard to say how reliable they are, it depends on may factors (number of links tracking, your hardware, number of clicks, dispersion of clicks per hour,... ). CCount does use file locking, but still for many clicks or links problems can occur.

With 2000 clicks/day I personally would rather use a MySQL-based script with daily (or hourly) statistics and not CCount.

moin1407 · Post by **moin1407** » Thu Nov 05, 2009 11:04 pm

Hi

I am using CCount in my wapsite http://wap360.net.
I like the script.
I converted 7750 links.
I Used 95 sub counters under 1 main counter. I added 100 links in one sub counter.

First I converted file link into ID in sub counter and I converted that sub counter link into ID again in Main counter.

Sub counters are for displaying on webpage and main counter is for total download counter on home page.

I used main counter's link on webpage as hyperlink.
main counter sends to sub counter and sub counter sends to file.

alhamdulillah.... Its handle 1000-1200 clicks daily

I havnt faced any problem yet...

Moin

DC · Post by DC » Fri Nov 06, 2009 10:06 pm

2000 clicks yes, best bet MYSQL as the flat file txt db can get currupted if it gets a bad write so althogh file locking helps it is not foolproof. The only way that a text based db script can handel a lot at once are when every file its writing too is seperate, a budy of mine builds his scripts that way and they can handel a lot as the script does not have to re-write a zillion lines of data.

So I think it depends more on how much data must be re-writen each time the file is updated as I have seen large files with thousands of lines of data crash as they get hit mid write and go currupt.

Ive seen this with both perl and php flat file db's

So if your going to be expecting a lot of traffic MYSQL is best.

DC

Post by **Klemen** » Sat Nov 07, 2009 6:25 pm

I agree with DC, you should really find a script with a MySQL database.

moin1407 · Post by **moin1407** » Tue Nov 17, 2009 7:13 pm

I published my site on 21/10/2009. I added 7754 links. On 11/11/2009 I faced problem in counter. suddenly It cut more than half of text file. it means it doesnt control more than 1 clicks at a time when it contains much links.

Now I am using databased counter! its performance is awesome and faster!

Moin

Post by **Klemen** » Tue Nov 17, 2009 8:05 pm

7754 links is 77-times more links that the recommended 100 ones so yes, a SQL database script should defenitely be used due to the limitations of text databases.

puniksem · Post by **puniksem** » Sun Mar 21, 2010 9:37 pm

moin1407 wrote:I published my site on 21/10/2009. I added 7754 links. On 11/11/2009 I faced problem in counter. suddenly It cut more than half of text file. it means it doesnt control more than 1 clicks at a time when it contains much links.

Now I am using databased counter! its performance is awesome and faster!

Moin

Could you not suggest what SQL script you used?