SPEED: mysql vs file

[crashmaster]

Hi there,

I have user system.

 

Every time, whn user something do - I store date and time of action in file.

 

I have a question. What is faster? To save in file or in db ?

 

(every users per 1 session could make about 400-1000 clicks)

[teng84]

this has been ask tons of times..  and the response i read is that if you need small storage use flat file otherwise DB

DB works fast than file

[Barand]

Presumably you store it for a reason and not just for fun. When it comes to analysing the content a db will win hands down.

[duclet]

Unless you need to use the data right away, I suggest using both. Store them to a file and then at set intervals, add them to the database as a batch. With that you said in the first post, adding each click each and every time it is done is going to kill your database (heck, that is why sites that receive a lot of traffic cache your database output). Always do batch inserts if you can so that you don't kill your database.

[crashmaster]

I store this actions for ONLINE user checks...