2011-09-07, 03:04
devicenull: the tables serve different purposes. Not all metadata is for the prime items. the movies table is only prime movies. The moviedata table is used to cache all movie metadata for any asin encountered. This would include My Library and the new feature My Queue when I commit it. the data in the movies table are always updated from a list source. the data in moviedata are always updated from page source. the list source is scraped for some things My Library.
I am also adding scraping items for some prime items as well. The past 30 days of new movies will always be a new scraped list. When the list is loaded any new items metadata for it is saved. It will also add those items to your prime library if missing.
what is a 1-to-N relationship?
why does it matter when I populate them?
I will make it one connection and use different cursors. I fixed that query.
I am also adding scraping items for some prime items as well. The past 30 days of new movies will always be a new scraped list. When the list is loaded any new items metadata for it is saved. It will also add those items to your prime library if missing.
what is a 1-to-N relationship?
why does it matter when I populate them?
I will make it one connection and use different cursors. I fixed that query.