Show Posts
1
ThumbsPlus v7-v9 Questions / SQL Database Conversion: what is file_time_iso for?
« on: 2013-06-26 09:28:52 »
Hi I have a massive SQL Server thumbnail database I'm trying to convert to v8 (for use in thumbs 9): some 26 million rows.
The upgrade has been running for about 5 hours and is probably only 5% of the way through.
I've checked the script (upgradeserver.py) and it is very close to the end. The "Populating new Thumbnail columns" step finished relatively quickly, but the slowness is on the "- iso times" step, which appears to be updating the new file_time_iso field to the file's time/date stamp.
After this all that is left to do (I think) is drop some obsolete columns.
However, at this rate the "update_times" step is going to take DAYS.
So my question is: Do I need to let this "update_times" step complete? What's the file_time_iso and thumbnail_time_iso fields used for (beyond being information properties)? What functionality in ThumbsPlus do I lose if kill the upgrade process as is leaving the vast majority of rows with these fields unset?(and probably manually drop the obsolete fields and tables using the script .py script as a guide)?
Many thanks
The upgrade has been running for about 5 hours and is probably only 5% of the way through.
I've checked the script (upgradeserver.py) and it is very close to the end. The "Populating new Thumbnail columns" step finished relatively quickly, but the slowness is on the "- iso times" step, which appears to be updating the new file_time_iso field to the file's time/date stamp.
After this all that is left to do (I think) is drop some obsolete columns.
However, at this rate the "update_times" step is going to take DAYS.
So my question is: Do I need to let this "update_times" step complete? What's the file_time_iso and thumbnail_time_iso fields used for (beyond being information properties)? What functionality in ThumbsPlus do I lose if kill the upgrade process as is leaving the vast majority of rows with these fields unset?(and probably manually drop the obsolete fields and tables using the script .py script as a guide)?
Many thanks