Or better yet, name the images based on the tables unique key, which makes dereferencing even easier. E.g., a row with PK 1234 has a file named img001234.jpg or whatever. So your directories/prefixes become table-esque, the filenames are foreign keys, and the files themselves are the data.
cheers, barneyb --- Barney Boisvert [email protected] http://www.barneyb.com On Mar 21, 2009, at 5:21 PM, Peter Boughton <[email protected]> wrote: > >> I also need to join to a table of images >> increasing the number from by a factor of 10 to approx 100,000 >> results. > > Don't store images in the database! > > Store images on disk, and store the filename in the database. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
