Thanks, Daevid I'll probably use something with session variables. However, what I wish is that there was some kind of application-wide variables, as can be set in ColdFusion, that could track this. I cannot find any means to create such variables in PHP. Anyone got any ideas on those lines? Cheers Terry ----------Original Message--------- > Or instead of creating a table and tying up one more mysql thread, just > save > the timestamp in a file. This could be as simple as that, you could use > XML, > you could use INI parser, you could use any number of things. Also, if > the > HEAP is created per "session", then just store that timestamp in a > session > variable and avoid any disk i/o that way. > > > -----Original Message----- > > From: Gary.Every@ingramentertainment.com > > [mailto:Gary.Every@ingramentertainment.com] > > Sent: Tuesday, July 08, 2003 9:24 AM > > To: moscow@cix.co.uk; php-db@lists.php.net > > Subject: RE: HEAP table > > > > > > Create a create_date table with one record, one or two > > fields, and put the > > last refreshed time/date in it. If that's expired, refresh > > > > > > Gary Every > > Sr. UNIX Administrator > > Ingram Entertainment > > (615) 287-4876 > > "Pay It Forward" > > mailto:gary.every@ingramentertainment.com > > http://accessingram.com > > > > > > > -----Original Message----- > > > From: moscow@cix.co.uk [mailto:moscow@cix.co.uk] > > > Sent: Tuesday, July 08, 2003 10:52 AM > > > To: php-db@lists.php.net > > > Subject: HEAP table > > > > > > > > > I have a query that I would have liked to cache, but as it uses > > > UNIX_TIMESTAMP and has a user variable in it, where cacheing > > > won't work, I > > > looked around for another way to do it (it is used to create > > > a smallish < > > > 50 records table on each web page, so any speed increase is > > > worthwhile). > > > > > > I decided to go for the creation of a HEAP table, so that > > > anyone accessing > > > the site would automatically access it. The existence of > > the table is > > > tested for before initial creation by running a select > > against it and > > > testing the $result variable. > > > > > > This works, as far as it goes, but it will require occasional > > > updating. > > > And that's where I've come unstuck. How can I test for the > > > time/date of > > > the HEAP table's creation? If I can find that, then I can set > > > a seconds > > > value past which it should be dropped and recreated. > > > > > > Any ideas? > > > > > > Using MySQL 5.0.13, php 4.3.2 (on Windows XP), Apache 1.3 > > > whatever. This > > > also has to work on the website proper, using 5.0.13/4.3.1 and IIS5. > > > > > > Terry Riley -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
