Đã hoàn thành

146887 statcounter web improvement

I have a statcounter website, premiumwebstats.com. I am suing a mysql database but it has slowed down when traffic has reached several million hits a day.

The service monitors not just page counts but also, browser, operating system, month, week and so on. A lot of data.

I am looking to optimize the program so it still runs under load.

First solution is to use text log files for each user instead of mysql. The information in the text files will be counted up with echo "into" [url removed, login to view] instead of using an update on the mysql database.

And the counting would use the size of the file. I would need a program to transfer the text log file data to mysql and then erase the text log files periodically.

The program would run as [url removed, login to view] joe, where joe is the user name in question

The programs, including the update program, should be written in php.

Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: web programs, programs for php web, erase a, mysql load text, load text mysql, file transfer solution, web page text size, transfer run file, web hits, optimize web, traffic log, optimize php mysql, million website hits, optimize operating system program, echo file php, php echo file, php file web service, mysql web service, web page browser, name hits, web service database, hits name, optimize php traffic, log traffic mysql, improvement website

Về Bên Thuê:
( 163 nhận xét ) London, United Kingdom

ID dự án: #1893065

Được trao cho:


This can be done. Though I might recommend optimizing your database and SQL queries before working with flat files. I can do some tests on your server for both solutions to determine which would be more optimal.

$100 USD trong 3 ngày
(0 Đánh Giá)