> probably the best one actually.. considering the volume of > the project inevitably... until we get 3000 photos in a single > day...
OK then. Add an "hour" directory to the previous algorithm. It doesn't really matter how many you get in a single timeframe, from the perspective of the categorization algorithm - you just need to ensure it goes enough levels deep. > Kinda funny though all the anti-binary data in the database... > Oracle most notably pitches the hell out of such and use of > BLOBs.... Yes, and Oracle spends a lot of money to get acceptable performance with BLOBs and non-structured data in general. MySQL, on the other hand, doesn't. > eventually we will be trying out some image intelligence stuff.. > like show me the pictures of night time.. or more interestingly, > show me the pictures of people only...not everything that will > be submitted will have corresponding human entered data so some > smarts will try to fill it in... > > in the long term there are larger applications and smarts though > to be discovered/attempted... At that point, though, you've left the relatively world of SQL. Who knows what we'll be able to do in analyzing non-text data in the near future? That doesn't necessarily have anything to do with storing that data, though, and if you're building your application now, it's worthwhile to keep that in mind. For example, there's no reason that the data categorization engine for your images would have to be embedded within your database - you could have it analyze incoming images, and then store the categorization results themselves (which will probably be more easily represented as text) within the database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
