[FX.php List] Database table modification

[Tim 'Webko' Booth]

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...

Cheers

Webko
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100513/eea87f12/attachment.html