php - Performance in LAMP: Filesystem vs. Database -

i need design website has friendly urls configurable specific users. must in database manage them (which user created it, module , data must load, etc.), , must have permissions system (view, actions, etc.).

the question is: have better performance if created php file each path (like /section/subsection/index.php) loaded directly apache, better if check every query in database, or depends of kind of page?

there 3 kind of pages: - static (once created won't need connect database) - periodically updated (i can delete pages when not updated) - dynamic (like load user events, require perform database queries)

is there existing brenchmark this?

without more substantial description of setup, number of entries in each section/subsection, kind of load, etc., noone can answer question you.

and really, except pathological use cases, noone should. should answer question benchmark data implementation.

the clear drawback can see in solution describe php files code duplication, managed if have automated creation of files.