in reply to Strategies for temporary image files in CGI
Please note: I'm not saying you should not automate via Excel, just that it does not seem very fit to me for serving images through a (busy) web server.
About your question, I'd create the file and store it within a table with a key that's related to its information and a timestamp. If - to say - we are talking about stock data, I'd store a key like "XXX-60" to mean it's the stock symbol XXX and the graph is for 60 days. Then I'd store the blob with your GIF and a timestamp. On loading, I'd query the database for a "XXX-60" created within the last five minutes; if not found, I'd create it and replace the old version in the database. I would not go for "real" files; they're harder to keep track of, will fragment the file system, and you need a CGI with a database connection to serve the request in any case.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: Strategies for temporary image files in CGI
by Itatsumaki (Friar) on Nov 21, 2003 at 17:16 UTC |