[FX.php List] Database table modification
Tim 'Webko' Booth
tim at nicheit.com.au
Wed May 12 20:51:23 MDT 2010
On 13/05/2010, at 2:06 AM, Duncan, Blair wrote:
> Just as a followup...
> My hacky solution although a bit faster still takes an incredibly
> long time 10 seconds or so to process, which is far too long - just
> to determine if a table has been modified.
> Here is where I am at:
> I have a table with about 15,000 records, the table has about 80
> fields 3/4 of which are unstored calcfields.
> Accessed through a layout that contains a single autoentered
> modifiedtimestamp field.
> I also have another table similar to the one above above.
> In PHP, I call a preFindScript that goes to each layout, sorts on
> the modified timestamp field and goes the last record.
> Comparing the timestamp and record count with a pre-recorded
> timestamp and record count enable me to determine if the table has
> been modified.
> Sorting seems to take the time which I thought that since the field
> is indexed would be much quicker.
The larger the set, the longer the sort time - if you are fairly sure
that *something* should have been modified in the last (24 hours / 2
days / week) - perform a find and sort on the results...
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the FX.php_List