Christian Hänsel wrote:
Hello Alain,
I can just tell you from my experience.
I have recently created a, in my eyes, pretty big project, and wanted to
track everything, starting from user navigation over search queries to
login/out times, article printout times and count, photo views and
everything your mind can imagine. I didn't do this for just the fun of
it, but to see what our users do on our website and to improve the
handling of the site.
Anyhow, I think you get the idea. Now, what I've done, was to write all
that into a mySQL database... and by now I think I shouldn't have done
that. I did a DB-backup today (after 4 weeks of having the site up), and
already the size of the DB is 10+ MB of textual data. What will it be
after a year...
245.23 megs (3%+/-) given a 10% increase each 4 week set
how do you have your table indexed?
I once worked on a project that we had add banner displays/clicks tracking.
we found that by turning off the indexing on the table, things went much faster and the size of the
DB didn't get crazy.
For your "something changed from 'this' to 'that' are you doing a full copy of each bit of
information, or are you doing a diff on the data and storing only the difference?
So I guess it really depends on what you have in mind. I do store a lot
of text data, so you might not even come up with 15% of what I'm saving.
I think you should do some planning and try to see how many users will
visit your page, and then calculate the amount of data your might be
writing to files or a database. From my point of view, a database
solution is just fine, until you have to restore that database from your
local computer with a dump (uploading and all :oP)
Just to show you what I dod and what amount of data I'm getting :o)
Cheerio!
Chris
""Alain Roger"" <raf.news@xxxxxxxxx> schrieb im Newsbeitrag
news:75645bbb0706120426t44ea1ea3p46d752636c9ec31f@xxxxxxxxxxxxxxxxx
Hi,
I would like to create a log system to keep a trace of all users' actions
(log-in, remove, change or update data, and so on...).
What should i do or to what should i take care to not have problem ?
I was thinking to create a folder on my server where log files will be
stored, but what is the best practice.
thanks a lot,
--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.2.4
PHP 5.2.1
--
Jim Lucas
"Some men are born to greatness, some achieve greatness,
and some have greatness thrust upon them."
Twelfth Night, Act II, Scene V
by William Shakespeare
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
