which is faster? mysql or file container

[redrum]

just like the title :p

[agamemnus]

I'm convinced that mysql is faster as normally you are writing and deleting to a file instead of to a database (which is almost ALWAYS memory based). Do you have any idea how to set it up, though? For me adding the parameters like "container_cfg_mysql_username" (like demo 55) just cause an error....

[agamemnus]

Ok, I figured out a small piece of the puzzle. I didn't set '$params["container_type"] = "mysql";'

[Chasingu]

So MySQL is faster? Now if i put it in so that it deletes all the posts after everyone leaves does the MySQL database delete the posts?

[agamemnus]

No, doesn't look like it.

The chat log seems to be still kept in a file. Not sure when it is updated though or where that is in the code. (If it was kept in the db the chat performance would be even faster.)

[TheRock]

so, to the best of my knowledge, mysql (a db) is better off than file based system.
and yes, you can turn of the file logging and just log to db, by directly modifying the file container class.
hope it helps

[OldWolf]

This thread is a couple months old... I don't think they're checking it any more.