Ask Your Question
0

getting changes from photos database which timestamp to use?

asked 2018-08-10 10:24:46 -0500

bscdata gravatar image

I don't know if others have run into this issue, and i did not have a problem till now(ignorance is bliss) the photo data base shows multiple timestamps and these seem to be the most relevant L_UpdateDate - _Last_Photo_updt - MED_update_dt. if you look they are all different times.

the L_UpdateDate reflects the change to the listing table. the L_Last_Photo_updt shows the change to the photo and the MED_update_dt is slightly different than the L_Last_Photo_updt.

i found relying on the L_UpdateDate does not get the changes if they happen within an hour or so. i am trying the MED_update_dt to see if that is better, what do you recommend,

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2018-08-13 10:08:38 -0500

Dates in the Media resource:
L_UpdateDate - Updated whenever listing data is changed. Not really useful for photos.
L_Last_Photo_updt - Updated whenever images are added/updated/deleted/reordered for the listing.
MED_update_dt - Updated whenever that particular media item is updated. A photo label change, for example may not be reflected in the Last_Photo_updt field.

When working with the Media resource, I would suggest that you use the L_Last_Photo_updt as your incremental. Then it would get all the image URLs for that property whenever the photos change.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-10 10:24:46 -0500

Seen: 15 times

Last updated: Aug 13