I use php4 (with zend optimizer and as apache mod) and mysql.
I am building a banner rotator where every banner is not just an image and link. Some are bigger and need specific html coding to work.
So, which scenerio is best:
A. Store html code in a file. Then have path to file in mysql DB. When it gets the query, it looks up the file path then includes that file into the page calling it.
B. Store html code in a text blob in mysql and get from there.
Any images will be stored on server and called via html so storing images is not needed.
I am concerned with speed and resources as this will be used heavily.
Also the machine is a dedicated box. 1 gig of ram, linux with tweaks and 1 gig processor.
Thanks!
I am building a banner rotator where every banner is not just an image and link. Some are bigger and need specific html coding to work.
So, which scenerio is best:
A. Store html code in a file. Then have path to file in mysql DB. When it gets the query, it looks up the file path then includes that file into the page calling it.
B. Store html code in a text blob in mysql and get from there.
Any images will be stored on server and called via html so storing images is not needed.
I am concerned with speed and resources as this will be used heavily.
Also the machine is a dedicated box. 1 gig of ram, linux with tweaks and 1 gig processor.
Thanks!