[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...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100513/eea87f12/attachment.html

More information about the FX.php_List mailing list