Refreshing stored data at administrator's signal

2008-01-13 Thread Colin Wetherbee
Greetings. I have an application that accesses some relatively static database tables to create drop-down select lists. As an example, one of these tables is a list of common commercial aircraft. At the moment (and not in a production environment), every time the drop-down list is

Re: Refreshing stored data at administrator's signal

2008-01-13 Thread John ORourke
Colin Wetherbee wrote: At the moment (and not in a production environment), every time the drop-down list is generated for a web page, the script queries the database to retrieve the entire list of aircraft. I would prefer to retrieve the list of aircraft when each Perl interpreter starts and

Re: Refreshing stored data at administrator's signal

2008-01-13 Thread Colin Wetherbee
John ORourke wrote: Colin Wetherbee wrote: At the moment (and not in a production environment), every time the drop-down list is generated for a web page, the script queries the database to retrieve the entire list of aircraft. I would prefer to retrieve the list of aircraft when each Perl

Re: Refreshing stored data at administrator's signal

2008-01-13 Thread Perrin Harkins
On Jan 13, 2008 4:19 PM, Colin Wetherbee [EMAIL PROTECTED] wrote: I thought about the file thing... if the file exists, check its last modified timestamp; if that timestamp is greater than the stored timestamp, then update the data from the database. It seems like unnecessary disk access,