Those are keywords entered by users when the store a document in the system. Stuff like destroy date, attendees, meeting type, etc..
On 2/10/06, Aaron Rouse <[EMAIL PROTECTED]> wrote: > Is the metadata something that is keyed in or do you grab it from the file > somehow? > > On 2/10/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > > > > We've got two tables set up: > > > > search_table > > :id > > :metadata1 > > :metadata2 > > :metadataN > > :file_type > > :file_size > > :file_id > > > > file_storage > > :id > > :image > > > > everything is stored in the database. The tables could have been > > combined into one, but we thought it might slow down performance if > > your having to deal with a blob object in all of your queries. The > > way we have it set up, we can run queries against the lightweight > > search_table and then retrieve the document from the file_id => > > file_storage.id relation. Also, given this technique, the > > file_storage table could easily be moved to another database, another > > server, or spread out to different databases. > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232002 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
