database cache

GoldenGoose

Joined: 2008-07-26
Posts: 1
Posted: Sat, 2008-07-26 17:30

My question pertains to the database of uploaded pictures and the cached data.

I am currently building a photo database that will contain serval thousands of pictures and have serveral people helping me with the keywording. Timing all of the uploads to the database is proving difficult for me. We have uploaded some albums that were not ready for upload. I would like to avoid this in the future(yes i could track the progress of keywording better).

If i could just upload the pictures to the database and have people "map" there to do the keywording? Experience has shown me that this won't update when viewing the web page. I have also noticed that when i delete files from the database directly it will not reflect in the viewing of gallery. I have crawled through much of the forums to find answers.

I have attempting to run the maintenance on the cache and rebuild thumbnails, which is returning a very looong list of errors that i'm attempting to make my way through. Which got me thinking about erasing the cache. Will this rebuild the database? though as the database grows it will take longer and longer to rebuld the entire database. Which spurred other thoughts, forcing me to d/l the developers kit.

Question

1) Am i correct in believing that updating keywords in the database is not currently supported?

2) Deleleting the contents of the cache folder on storage drive, may force the gallery to rebuild the database from scratch and retrieve(iptc data) any changes made to it?

3) how much work will it be for me to modify the the rebuild thumbnail option in maintenance to rebuild the IPTC data on pictures or is that a good route to take?

since i posted my question have done some more research and found that it is won't be that simple.

I have to update the mysql database, when i make changes to the files and not the database none of my changes will be captured! will i have to do some maintenance to gallery after i figure out how to update Mysql? i think i will.