Forum Moderators: coopster

Message Too Old, No Replies

Save to file or save to db?

Which would be more efficient?

         

planbeta

12:21 pm on Jul 12, 2003 (gmt 0)

10+ Year Member



I am working on a web fetch tool and I want to save potentially 1000's of whole page data, be call back from a seperate script

What would be the most server efficient way of calling back this data? From a saved html page? Or from the whole page data saved in a MySQL field?

I'm guessing the MySQL way would be the way to go?

Thanks

Chris

vincevincevince

1:04 pm on Jul 12, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



incorrect guess.

assuming you will be getting a reasonable slice of traffic - generating physical .html files once for each will be vastly more server load efficient.

apache just has to serve the .html file complete - no involvement of php or mySQL etc. nothing is more server efficient than that.

the only server load will be in the writing the original page, should you do that with php/mySQL.

planbeta

2:36 pm on Jul 12, 2003 (gmt 0)

10+ Year Member



Cheers Vince